Dec 07 2022 03:18 AM
Hello,
Triggered from a selection (change) in a drop-down list in cell A1 excel should automatically copy only the resulting numeric value of cell A2 (containing a formula) to cell A3 with A3 is an empty cell receiving only the numeric value of A2 (similar as doing a manual copy - paste). Finally, A3 should not contain a formula but only the value received (copied) from resulting calculation in A2. How can this be achieved without using a formula in A3 and not using a Macro/VBA?
The reason for this requirement is to run the excel spreadsheet on a public shared platform such as SharePoint, OneDrive or other online service provider, which all together do not allow to run Macros/VBA on their platforms.
Dec 07 2022 10:55 AM - edited Dec 07 2022 10:55 AM
Finally, A3 should not contain a formula but only the value received (copied) from resulting calculation in A2. How can this be achieved without using a formula in A3 and not using a Macro/VBA?
The reason for this requirement is to run the excel spreadsheet on a public shared platform such as SharePoint, OneDrive or other online service provider, which all together do not allow to run Macros/VBA on their platforms.
Have you been able to find a solution? Not really, right? Because within the constraints you've stated, there ain't one. Content doesn't appear in a cell all by itself. There's either a formula in the cell, or a VBA routine to put it there (or a human being doing the copying and pasting).
Now, your second paragraph quoted above does not contain the prohibition on formulas, so maybe you overstated it in the first....... I just noticed you've had over 40 views and no replies, so thought I'd see if we could move it along. Do you care to modify/clarify the requirements?