Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Divide rows equally & extract first & last of each block... Possible?
G'day Gents,
I have about 8 spreadsheets with anything from 1109 to 1911 rows in each (addresses) I also have some VBA code that will divide the number of rows equally & colour each block of the addresses, making it a bit easier to find the first & last address. Is it possible to copy the first & last address of each block into a new worksheet automatically. Any help would be GREATLY appreciated. (Background) This is for posties, so when we work short-staffed & have to divide a delivery round(s) amongst the rest of the staff we can quickly & accurately set up the divide. At the moment it still takes the better part of 1/2 an hour to set up just 1 divide. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide and copy rows | Excel Programming | |||
divide records equally among multiple employees | Excel Worksheet Functions | |||
Extract phone number front block of text | Excel Discussion (Misc queries) | |||
select block of rows w/data between blank rows | Excel Programming | |||
I Need to divide all cells in rows 2 and 3 by 100 | Excel Discussion (Misc queries) |