can you group multiple worksheets into a sub menu

G

Guest

Here is what I'm looking at doing. I have made 3 seperate workbooks with
probably 10 worksheets per workbook. Each worksheet is linked to the other
worksheets in a given workbook and these sheets often contain complex
calculation equations. I am trying to merge these 3 workbooks together into
one master workbook. Instead of having a Master with 30 worksheets I would
like to have a master with 3 subfolders that when you select a particular
subfolder the 10 worksheets specific for that subfolder are available to be
selected.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top