Forum Discussion
Copy calculated value in cell A2 to cell A3 not using a formula in A3 and not using Macro/VB
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?