| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete correct # of rows
I want to use a macro to clean up a file and save time. The Requests Found
field is the maximum # of records that can be deleted. So I could have 1 record with a max of 1 to delete or 5 of a record with a max of 3 to delete or 1 record with a max of 7 to delete. I assume I will need to loop through the rows - any suggestion would be appreaciated. Thanks, Krystal SAMPLE DATA: ACCT_NO Requests Found 289278995 1 289278999 1 289278999 1 289278999 1 870587008 1 119387014 1 158675527 2 654375649 2 569777245 2 752478468 2 752478468 2 396378512 2 396378512 2 396378512 2 396378512 2 399778090 3 399778090 3 399778090 3 208777882 4 208777882 4 208777882 4 208777882 4 987178737 4 987178737 4 117468837 7 117468837 7 117468837 7 117468837 7 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dup check 2 columns - need it to delete correct one | Excel Worksheet Functions | |||
| inserting correct number of rows | Excel Programming | |||
| Inserting Rows and Maintaining Correct Balances | Excel Discussion (Misc queries) | |||
| How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Threaded Mode
