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


--
JP2R


------------------------------------------------------------------------
JP2R's Profile: http://www.excelforum.com/member.php...o&userid=23582
View this thread: http://www.excelforum.com/showthread...hreadid=385125