Copy calculated value in cell A2 to cell A3 not using a formula in A3 and not using Macro/VB

Occasional Visitor

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.

 

1 Reply

@JochenKa 

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?