undefined
Each morning a spreadsheet is sent to various regional managers - The person who generates this just creates another row - It is sorted by date - and separated by an empty row.
So I may have two rows with column "A" as a date, "B" as a problem, "C" as something else, "D" as a region...etc. Then a blank or empty row, then the yesterday's section..there may have been 3 or 4 rows of data...and so on...
So...what I have been doing manually is to search for the empty rows and delete all but the last one...
Then I do an AutoFilter...
Then I sort Column "D" - Region - one region at a time ( I am responsible for 15 or so ) once it's sorted for a specific region - I select the entire series of rows pertaining to that region and copy and paste to a separate worksheet in the same workbook for that region.
I wasn't sure where to start...I was trying to create a macro...one at a time and then maybe I could put them altogether...and create one complete macro...first to eliminate those empty rows..all but the last one...
I would really appreciate any assistance anyone could offer...
Bookmarks