Linking cells in one sheet to cells in another

[Dougie1]

Hi all,

Anyone got any suggestions how I can set up a sheet so that when I click in cell A1 of sheet 1 I will automatically be taken to cell A1 of sheet 2, when I click in cell A2 of sheet 1 I will automatically be taken to cell A2 of sheet2 etc.

Thanks in advance.

D

 

[Lewiy]

Try using hyperlinks, set the detination as "Place in this document" and pick the place you want to go.

 

[Expiry]

If you go to the tools, options then edit tab, you can disable the Edit Directly In Cell option. Then when you double click on a cell, it will automatically take you to the cell you're linked to even if it's in another workbook (ie. it will open that workbook for you).

 

[Dougie1]

That works just great Lewiy.

Many thanks for your help.

D