Hi,

does anyone know if it is possible to remove records from one
spreadsheet based on the entries in another spreadsheet?

i'll try to explain. i have a spreadsheet taken from an door control
system, with each row containing a card number and name. this file is
about 4500 rows long. i have another spreadsheet which has a list of
about 1000 records, again with card numbers. basically the second list
is people who have left and need removing from the system. is there a
way i could get excel to remove all records from file one if the card
number is in file 2?

any help would be really appriciated.

Thanks


--
Gopher_By_Fende
------------------------------------------------------------------------
Gopher_By_Fende's Profile: http://www.excelforum.com/member.php...o&userid=35318
View this thread: http://www.excelforum.com/showthread...hreadid=550944