E
excelguy03
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
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