hey, i'm creating a database on excel and i've come across a problem, on sheet "database" i have data starting from b2-e2, headed, reference number, product name, description , date respectivley there is data underneath and keeps adding. what i need is a macro code to do the following, i want to search the value of cell L23 on sheet "home page" which is a reference number, and locates it in the database sheet. i then want to copy that row to sheet1. then i want to be able to change the data on sheet 1 which will then update the data on database, as well as creating an option to delete the that row. thanks hope you can hope