Excel sheet linking

[Andy™]

is there a way i can get a box (i.e A1) to go to another worksheet (i.e sheet 2) if i click it?

 

[Apache]

How do you mean? Like a hyperlink to click or so what you type in a box in 1 sheet is copied to another sheet?

We are talking about the same excel file?

 

[Andy™]

something like that patch, its all in the same xls file. there will be about 15 sheets, id like a link on first sheet which can then go to any sheet i click link to, and a link on each sheet going back to start

 

[Apache]

you on excel 2007?

 

[Andy™]

yes

 

[Apache]

If you are make your contents page and name a cell sheet 2, sheet 3 etc (or whatever you choose)

Select the cell with the cursor

Insert menu > Hyperlinks

Box appears, LHS select 'place in this document' will let you chose which sheet to link to

Can create a link back the same way

 

[Andy™]

so simple....

Thanks

 

[Apache]

so simple....Thanks

Anytime

 

[Robojin]

For a single reference

if Sheet1 cell A1 has

 

[Andy™]

i think ill stick to patches method - much more simple!

 

[Robojin]

i think ill stick to patches method - much more simple!

:| ; )