Combine worksheets if...

Hi everyone,

I'm tinkering around with my macro right now and I need some help. At one point, my macro takes the data and splits it into several tabs according to name in a certain column.

This part works great. The problem is that it splits it into too many tabs. I'd like to combine them (or just keep them from splitting) depending on the name of the labor type.

What I'd like:

1) Combine if the first 8 characters of the Labor type/worksheet name are identical.
2) Also, combine all Clerical/Tech labor and Temp labor.
3) If there are two sheets that fit criteria 1 or 2, take the second sheet and move the data (minus the header row) onto the first sheet in the next open spot.

Here is my code that is used to split up the "Labor" tab into all the other tabs.

Please Login or Register  to view this content.

I've also included a sample workbook which includes some of the different labor types and tabs that go into a normal workbook

Thanks ahead of time!