Linking. Need help asap pls!

**Roula** · 03-05-2009, 05:47 AM

Hi,

I'm trying to create a link from the headlines in the table on the 'Time management matrix' to the respective tabs with the same titles, so that when I am in the first tab, and I click say on cell C4 - 'Dry food (staples& grains) -Rice' I would automatically be shifted to the 'Dry food tab' cell A1.
Is this possible?

Thanks.

**martindwilson** · 03-05-2009, 06:43 AM

cant open that but insert hyperlink to named location in file will do it

**Roula** · 03-05-2009, 06:50 AM

There must be something wrong with how I'm entering the address under 'Insert hyperlink' and I'm not sure if I can put in the name of the tab and cell no.
Whenever I do that I get a 'Cannot open file' error message.
The worksheet is saved in a shared folder:
'Z:\Business Development\[TimeManagementTable2009.xlsx]Dry Food'!$A$1

Is the above address a correct format?