Create multiple tabs in a spreadsheet from information in columns

Hi - Hope everyone is doing well.

I'm working on a spreadsheet which I would like to find an automate way to produce, currently column headers are like this:

Sanned LP Matched Pallet # CA or OH

I would like to create new tabs based on the information in the column Pallet # and CA or OH.

Not sure how to explain what is needed so I've included a sample spreadsheet of what the final workbook will look like. Sheet 1 is where all of the information will be stored, that sheet should the be used to create the additional tabs once the user has finished populating Sheet 1.

Any help on this task will be greatly appreciated.

Column_TestII.xlsm

@mikerickson - Thanks for your efforts in scripting this out. I have place this code into the production spreadsheet and it created the tabs as requested, however there was a side effect, when the code runs it creates 2 additional tabs with no data. For example if DOOR HEOH has 5 pallets and DOOR HECA only has 4 pallets it creates a 5th tab for HECA with only the headers, I added an example in the attached zip file.

Any way to avoid this side affect?

HeilindAuditDoc-Tabs.zip

Originally Posted by mikerickson

Try changing this

Please Login or Register  to view this content.

Excellent! It worked perfectly. Thank you very much for your help.