Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy rows between two criteria
I have a workbook that I want to sort out. At the beginning of the
sort is a route name and at the end of the sort is "Zone Total" each time. What I want to do is sort all rows between these two rows and paste the correct routes in a corresponding worksheet. Example: Route 104 Data Data Data Customer Customer Customer Zone Total Data Data Data Route 105 Data Data Data Customer Customer Customer Customer Zone Total Data Data Data And so on All rows between route 104 and zone total will go on a sheet and all rows between 105 and zone total will go on a sheet. It will be the same routes everytime but with possible different customers. I know how to do simple loops but I am having trouble starting this. Any help will be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Rows using criteria | Excel Programming | |||
Automatically copy rows based on criteria | Excel Discussion (Misc queries) | |||
Copy rows that meet a certain criteria | Excel Programming | |||
copy rows meeting criteria to another worksheet | Excel Worksheet Functions | |||
Copy Rows if Lookup Criteria Match | Excel Discussion (Misc queries) |