Does anyone know if it possible to copy a cell value from the same row the link is on a paste it in another cell on another sheet.
I.e Values are in Column A and the link would be in Column B and copy to sheet 2 cell A1
Col A ----- Col B
1212 ----- Click Here < would copy 1212 to sheet 2 cell A1
7474 ----- Click Here < would copy 7474 to sheet 2 cell A1
2939 ----- Click Here < would copy 2939 to sheet 2 cell A1
The cell "a1" on sheet 2 must remain formula free
I have got about 40 of these rows that need this type of link and the data in Col A changes everyday.
I hope this makes sense
Thanks in advance