Excel spreadsheet - referencing other sheets.

[willhub]

Hello.

Apologies if this is in the wrong section.

I'm hoping this is possible.

If you've got a spreadsheet with lots of hyperlinks to other spreadsheets, so Imagine you're going down a hierarchy and before you know it you're lost deep inside this web of spreadsheets, and want to come out then go backwards to the top, and you then find it's hard to remember what route you've taken, so something like a "file path" would be useful and on each page, a reference to where you've came from would be good.

So what I'm looking for, is there a way to display the patch I've taken through this web of spreadsheets so that it's easier to navigate and remember paths?

Any help would be great, thanks.

 

[OspreyO]

There are probably didn't ways to do this. I googled "show which worksheets link to the current worksheet" and found a load of solutions. Some in VBA...

http://www.datawright.com.au/excel_resources/show_which_worksheets_link_to_the_current_sheet.htm

However like that joke about directions. "Well I wouldn't start from there"

You might consider that there may be a better way to do this than a maze of spreadsheets. Perhaps you need one database with all this data in it, that you can export anything you want from it.

 

[willhub]

Thanks that's great, will give this a try tomorrow!

It's for work, anything we want to find at the moment we just CTRL + F , but then we need to know the path taken to navigate the same path on a different system. I'm not sure they'd want to spend the time/money on rustling a database up, it would be better though!

 

[OspreyO]

At some point you have to let go the horse and learn to use a tractor. For your own personal development. It would be good to do a database course. It would save you a lot of work and hassle You can use it as back end to your excel sheets. Excel and VBA is a great and powerful There comes a time though, when its holding you back.