Each week I receive an excel report where I need to separate the data into new tabs.
The first column contains, for example 700 lines with the same repeating name and then 200 lines of the next repeating name and then 300 lines of the next repeating name etc. Each week the 700, 200 and 300 numbers will vary. It may be 720,195 315 etc.
I would like to have a macro that will read through each of the repeating names and put them each into a new (separate) tab on the workbook. If the numbers did not vary I could just record a macro to cut and paste but I don't know how to deal with the varying number of rows.
I've attached a small example of a spreadsheet.
Thank you
Bookmarks