View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mwam423 mwam423 is offline
external usenet poster
 
Posts: 103
Default deleting rows in large database (+20k rows)

i need to delete all rows whose account numbers do not match a set of 20-30
account numbers. since the database is quite large was planning to use Union
application to create range of rows to be deleted.

what is easiest method to distinguish between rows containing the 20-30
account numbers i want to save and the hundreds which need to be deleted?