hey guys.

I have two worksheets. One contains a summary of all data i have
entered. there are four rows. ID, Name, Address & Phone number.

In my other worksheet, I have used a vlookup function to search for the
id, then display the corresponding data according to it's name address &
phone number.

What I want to have is that when I search for a particular id and it
displays the rest of the id's data, I want that row deleted from the
summary worksheet.

Any ideas on how I do this?

Thanks


--
excelguy03
------------------------------------------------------------------------
excelguy03's Profile: http://www.excelforum.com/member.php...o&userid=34032
View this thread: http://www.excelforum.com/showthread...hreadid=537933