Hi,
I got 2 worksheets containing data of students. what i want to do is,
find all the data of worksheet1 in worksheet 2, and delete entire row
containing all the data. e.g.

worksheet 1:
name ID No
NIK ANIS AMIRAH BINTI NIK IZANI 871007145768
NIK HIDAYATUL IZNI BINTI MOHD HATTA 870515105020
NIK IKHWAN HAQIM BIN HANAFI 871106295171
NIK MOHAMAD FAIDHI BIN NIK AZLAN 870206295481
NIK NUR AMALINA BINTI MAT ZAIDAN 870709035606
NIK SAIFUL LIZAM BIN NIK MOKHTAR 880415065315

i want to find all of these students in worksheet 2 and delete them
(entire row).

so any idea how to do that instead of using find & replace 1 by 1? for
info, worksheets 2 containing more than 2000 students data.

thanks.


--
sulie
------------------------------------------------------------------------
sulie's Profile: http://www.excelforum.com/member.php...o&userid=24063
View this thread: http://www.excelforum.com/showthread...hreadid=376980