Return the value of an active cell, dynamically

[Brett Mercier]

Hello,

Not sure if that can be done without VBA, but I sure hope so!

Is it possible to return the value of the active cell (ie the one selected by your cursor) in another cell?

For example A1="Active Cell"

If I click on a cell where the numerical value is 12, I would like the A1 cell to automatically show "12" as well (and I would use A1 as an input in formulas elsewhere on the sheet). If I then click on a cell where the value is 15, A1 would show 15 instead.

Thank you!

[FDibbins]

Is it possible to return the value of the active cell (ie the one selected by your cursor) in another cell?

no, this will require VBA

[Brett Mercier]

no, this will require VBA

Arg, ok... Would you know what kind of macro I should create with VBA to achieve the desired result?

Thank you