MACROS: Sort by multiple criteria - Create tabs based off of criteria

I am trying to create a fairly complex macros for reports that I do at work.

We are currently using macros and this accomplishes about 70% of what we would like to do. Here is our current macros:

Please Login or Register  to view this content.

This takes a list of information and breaks it out into tabs in Excel based on the names as well as formats them. There is one problem with this. After this break-down happens I need to further break down those tabs based on another column containing invoice numbers. So for example I would have the following tab titles (Apple (Invoice 1), Apple (Invoice 2), Microsoft (Invoice 1), Microsoft (Invoice 2)). Is there anyone that could help me?

Thanks,
Sean

Welcome to the forum.

Please take a few minutes to read the forum rules, amend your thread title appropriately, and edit your post to add code tags.

Thanks.