View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Murrell54 Murrell54 is offline
external usenet poster
 
Posts: 2
Default creating tabs with sub tabs

Can you create a hierarchiacal relationship with Multiple Workbooks?

"PJFry" wrote:

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

--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"Murrell54" wrote:

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