View Single Post
 
Old 03-17-2015, 09:37 PM
Guessed's Avatar
Guessed Guessed is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You could write a macro but it is faster to do it manually for a one-off task.

I would select the table and then sort it on the last column. This puts all the rows containing something in Field 3 in one continuous block so it is easy to select and delete.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote