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