If I correctly understand Nader's requirement he would like to
hyperlink each cell in one sheet to the corresponding cell in a second
sheet (not all cells to cell A1 of the second sheet). I am not aware
of a simple copy and paste route that would accomplish that, but can
offer the following macro
Hi Nader,
You can do this in one Go.
Activate the second sheet. In the Cell A1, write "=" without double quotes
and then go to Sheet 1 and select A1.
Press enter.
Press F5 and enter the last cell till where you want to hyperlink (say M500)
Press Shift Enter.
Press F2 and Ctrl+Enter.
This will hyp
