Hi All,

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

Sheet 1

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

Crampz