Hi-

I'm hoping this is an easy fix, but I have this code that I found elsewhere. It does exactly what I need to do for column A. However, I need the code to run in column Z. Basically, it's looking at the information in that column and splitting it out onto new tabs accordingly (based on the information that's in that column). I have a sheet that has a list of 10 or so vendors and the products they purchased. The sheet itself may have 50,000 lines, but there will only be 10 vendors on the list. I've been able to manipulate the code a bit, but all I've been able to do is get it to rename the tab after the vendor and bring the header row over. It is not bringing over the information in the other columns like I need it to.

Anyway, this code below works, but I need to change it to sort and move the data by column Z instead of column A. And I cannot get it to work like I need it to for the life of me.

Please Login or Register  to view this content.