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