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...