I work for a buiding maintenance company, and need to organise lists of equipment for buildings we maintain throughout the country.
What I'd like to do is to create an excel file for each customer, which opens up to display tabs along the bottom for each geographic area of the country. Clicking on a tab for a given area then reveals another workbook, with a new set of tabs for all the individual buildings within that area.
Note that I'm not talking about using hyperlinks linking to external workbook, but somehow setting the tabs to open workbooks within the same view, as opposed to individual worksheets.
I've seen this done, so I know it's possible, but I've looked extensively and can't find anything.
Any of you Excel wizards out there know how to do this?
2007-06-06
06:25:17
·
2 answers
·
asked by
Anonymous