Write content of active cell of Sheet1 in a cell of Sheet2

Hello,

I have a file with the sheets Sheet1 and Sheet2

When I click onto cell A4 in Sheet1, the content of this cell shall be displayed in a cell (e.g. A2) of Sheet2.

When I activate another cell in Sheet1, the content of A2 in Sheet2 shall be updated.

Thank you very much for every hint.

Florian

So you want the value of whichever cell on Sheet1 is selected to reflect in cell A2 on Sheet2?

If so, try this in the worksheet module:

Please Login or Register  to view this content.

BSB

Hi BSB,

thank you so much for your prompt reply.

Works perfectly!!

Regards

Florian

Happy to help

Don't forget to mark the thread as SOLVED if you're happy you have a working solution.

BSB

Just a question:

Is it also possible to display the address of the selected cell of Sheet1 in A2 of Sheet2?

Florian

It is possible:

Please Login or Register  to view this content.

BSB

Coooool; thanks a lot!!!