coliervile
07-19-2006, 05:44 PM
I'm designing an Excel database that utilizes VB "userform" to input data into the main Database. What I want to do is look in Column "A" (called "NAME") for one name of an employee and copy that row of data to a "new" worksheet that houses that employees data and there will be duplicates of the same name. That is okay we want each row of data for each employees. I don't have the exact file, so I'll attach one that I already have. In the main database "OvertimeTotals" in the column "A" "NAME" there is the initials "AA" (stands for Adam Apple). There's another worksheet "Adam Apple" that I want to copy all of "AA's" rows of data from the "OvertimeTotals" worksheet to this worksheet "Adam Apple".
Can this be done from the "userform" for each employee or is it better to have a VB code for each employees worksheet?
Thanks for your help
Charlie
Can this be done from the "userform" for each employee or is it better to have a VB code for each employees worksheet?
Thanks for your help
Charlie