software

hey guys.

I have two worksheets. One contains a summary of all data i have
entered. there are four rows. ID, Name, Address amp; 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 amp;
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: www.excelforum.com/member.php...oamp;userid=34032
View this thread: www.excelforum.com/showthread...hreadid=537933