insert a column and add a formula =row() for every record - copy this
data and save as values

set up a filter on the database

select custom filter - is not equal to #N/A

cut the records out you don't want and paste below

remove the filter

sort the original records by original row number


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556008