Link Cell to another sheet

[srizki]

It must be easy to do, but I could not do it.
I need to link cells in sheet one to same cells in sheet two. I can do it one by one but there are over 200 that I need to link to.
So if I click cell A1 on sheet one, it should take me to cell A1 on sheet two.

Thanks

 

[VoG]

Select the cells on Sheet1 and copy them. Go to Sheet 2, Edit > Paste Special and click the Paste Link button.

 

[srizki]

VoG, Thanks but I should explain my question, some one will type an amount on say cell A1 and on sheet two cell A1 he want to type a corresponding project number, so he will type amount and the amount will become hyperlink and if he clicks the amount that should take him to A1 of the sheet two. etc. Same with all other cells.

Thanks

 

[jim may]

With Sheet1 active click on cell A1; Select Copy;
Click on Sheet2 than Cell A1, Edit, PasteSpecial, Paste Link.

On the pasted cell (Sheet2-Cell A1) go into EDIT MODE (F2)
Remove any $ signs form the Cell references changing it from Absolute to Relative referencing.

Then Copy this same A1 to the other cells in Sheet2; Done

As you enter data into Sheet1 it will automatically appear in the same linked cells in Sheet2.

Hope that helps...

Jim
That will do the initial Set up on Sheet2.
Now

 

[srizki]

Jim Thank you, but I do not want the sheet one data appear on sheet two, I will be typing some other numbers on the corresponding cell in sheet two, I just want the link so that If I click on the amount on sheet one, it should take me to same cell in sheet two.
I am thinking now that it is possible without code.?

 

[VoG]

I think that you need code. Right click Sheet1's tab, select View Code and paste in

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Application.Goto reference:=Sheets("Sheet2").Range(Target.Address)
End Sub

then press ALT + Q to close the code window. Double click a cell in Sheet1 to be taken to the same cell in Sheet2.

 

[srizki]

VoG,
that is working exactly as I wanted,

thank you so much.

Sohail