I currently have a spreadsheet with 28 columns and a header (A-AB). The rows and data will vary every month. I would like to spilt the worksheet into as many worksheets depending on the data in column AB and then name the worksheets according to the data in column AB and bring all the DATA over from connected to the name in column AB. Including blanks, amounts, dates, etc. So if column AB has the name Janet, George, Stephanie. I would like it to create a tab with the names janet, George and Stephanie, then bring all the rows associated with each name into the proper tab. There is usually 10,000 plus lines everytime, so I would need it to process fast and efficient. I have tried various codes but cant seem to get it right. Any help/suggestions would be greatly appreciated.