I have a worksheet containing an index of reports contained on a USB device. I have changed the index to be hyperlinks so you can easily open the file.
With it being a USB device and therefore the path of the files may vary depending on who and where the files are accessed I set up the links so it knew the path was wherever the index was however then in a different folder at that level i.e.
=HYPERLINK("./2009 Reports/"&F13,TEXT(C13,"0)")&" "&D13)
Where column F contained the workbook name, column C the report number and column D the friendly name.
I have moved these folders containing the reports around to help me with another issue I am having and now the index file is not on the root of the device.
I therefore need the hyperlink to search for a folder one level up from where it currently is, for example once a report has been open if I want to follow a link back to the main index (which sits a level above where the report I am currently in sits).
Apologies if the explanation is poor, my head is battered.
Any help would be appreciated.
With it being a USB device and therefore the path of the files may vary depending on who and where the files are accessed I set up the links so it knew the path was wherever the index was however then in a different folder at that level i.e.
=HYPERLINK("./2009 Reports/"&F13,TEXT(C13,"0)")&" "&D13)
Where column F contained the workbook name, column C the report number and column D the friendly name.
I have moved these folders containing the reports around to help me with another issue I am having and now the index file is not on the root of the device.
I therefore need the hyperlink to search for a folder one level up from where it currently is, for example once a report has been open if I want to follow a link back to the main index (which sits a level above where the report I am currently in sits).
Apologies if the explanation is poor, my head is battered.
Any help would be appreciated.
