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...
 
Top