LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LoriM
 
Posts: n/a
Default auto deleting defined rows

Hello all. I am working with a 20,000 row data spreadsheet. I have a list of
the rows that need to be deleted (i.e., 31, 38, 52, 66, 81, etc.). There is
no pattern to these rows, just bad data rows that need to be removed (2,000
in all).

Is there a way to automatically define which rows to delete? At the moment,
I am manually going through the list and selecting/deleting. I am pretty
green at programming so detailed answers are very much appreciated!

Thank you all for any suggestions.

LoriM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find duplicate rows then deleting them SSHO_99 Excel Worksheet Functions 4 May 4th 07 11:17 AM
How do I resize a worksheet after deleting rows? Jay Jay Excel Discussion (Misc queries) 2 July 25th 05 09:31 PM
Deleting unwanted and empty rows.... Jim New Users to Excel 3 July 5th 05 05:21 AM
Deleting unwanted and empty rows... Jim Excel Discussion (Misc queries) 2 July 4th 05 11:12 PM
Column Auto Width and Hidden Rows KWCounter Excel Discussion (Misc queries) 1 May 20th 05 12:59 AM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"