Hello Buddy8,
Try the following code in a standard module:-
Attached is your sample file with the code implemented. On the Database sheet, I have created a search box in cell A2. Type a (first)name from Column C into the box (case insensitive) and the relevant row of data will be transferred to the Archive sheet. I have also assigned the macro to the DataBase tag at the top of the page so it is now actually a button from where you can run the code. Click on the button after typing a name in the search box.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks