Click Cell, export value to another cell

[trader07]

I have a range of cells which hold numerical data, A2:E21. I need a VBA script or a Macro that, when any single cell in the range (A2:E21) is clicked on cell I2 populates with the value. Does anyone have a solution for this?

Thanks in advance!

trader07

[pike]

Hi trader07
Would a double click do?

Please Login or Register  to view this content.