creating tabs with sub tabs

M

Murrell54

I want to have tab named for a specific category, then have multiple subtab
worksheets for specific jobs In that Category.
 
P

PJFry

You cannot imply a hierarchical relationship between excel worksheets. Each
one is independent. What you can do is use a naming convention or a color
scheme to relate them. You main worksheet can be Data and the ‘sub’
worksheets could be s1Data, s2Data, s3Data. If you wanted subs to the subs,
say s1Data, that could become s1s1Data, s1s2Data, ect.

I don't know if that is what you want...
 

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

Similar Threads

tabs and "sub-tabs" 1
Reference the same cell based on tab name 1
SyncToy 2 problem with syncing 5
Access Access DB Form Limit Hit 0
VBA: How can I use a string variable as autofilter criteria? 4
Sumif to multiple tabs 1
Serious Excel Challenge 0
Validation list with formula? 3

Top