Open worksheet from cell in Excel - possible?

  csqwared 20:48 27 Jun 2005
Locked

I have a workbook containing multiple worksheets, the first sheet has a list of all the other sheets in the book (Each sheet number in a cell). Can I open a worksheet from the relevant cell in the first sheet. Hyperlink works but because of the path it won't transfer, say from My Documents to external storage media. Any ideas anyone.

Ta.

Carl

  VoG II 20:57 27 Jun 2005

Download ASAP-Utilities click here

On the ASAP menu, Sheets | Create an Index Page...

I don't understand "Hyperlink works but because of the path it won't transfer, say from My Documents to external storage media." Do you mean a worksheet or a workbook?

The easiest IMHO way to switch from sheet to sheet is to right click the arrow area just to the left of the sheet tabs and select from the pop-up list.

  csqwared 21:01 27 Jun 2005

Thanks for that VOG - I'll give it a try. I need to be able to transfer this workbook to other machines with different path names than the original hence Hyperlink not suitable.

Thanks again but I'll leave unticked for now in case of other problems.

Carl.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?