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

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.

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.

Sure, I can help you with that! Here's how you can create tabs with sub tabs in Microsoft Excel:

1. First, create a new workbook in Excel and give it a name that reflects the category you want to organize. For example, if you want to organize different projects for a client, you could name the workbook "Client Projects."
   
2. Next, create a new worksheet by clicking on the plus sign (+) at the bottom of the screen. This will create a new tab at the bottom of the workbook.
   
3. Rename the new worksheet to reflect the specific job within the category. For example, if the category is "Client Projects" and the job is "Website Redesign," you could name the worksheet "Website Redesign."
   
4. Repeat steps 2 and 3 for each job within the category. This will create multiple sub tabs within the main category tab.
   
5. To move between the sub tabs, simply click on the tab at the bottom of the screen that corresponds to the job you want to work on.
   
6. You can also change the color of the tabs to make them easier to distinguish. To do this, right-click on the tab and select "Tab Color" from the drop-down menu. Choose a color that corresponds to the category or job.

That's it! You now have a workbook with tabs and sub tabs that will help you organize your data and projects. Let me know if you have any other questions or if there's anything else I can help you with.