Hello,
I've a training database with macros that function like this:
1. Search for the name of critera cell (Update sheet) in Database sheet,
2. Copy & paste the training data (Update sheet) into the adj cells of the Database sheet.
These 2 steps are done via 2 different macros depending if the employee has existing training data set or not.
As you can see, this set of macros allows me to update training data according to each employee's name and is good if the particular training workshop concerned has only 1 or 2 employee(s) participanting. However, there are workshops that will have like 10 to 15 employees participating. If I'm using the current set of macros for recording, I'll need to enter the training data 10 to 15 times (which is very tedious). Therefore, I would like to have a "reversed" type of macro(s) whereby I enter the training data together with a checklist of names which I'll check for those that have attended the workshop. Then the macro(s) will allow me to update this whole set of data into the database accordingly.
I know this is a huge macro and requires a lot of thinking so I wouldn't be expecting anybody to build the macro for me. What I'm interested is what are some of the initial steps for the desired result because I don't even know how to start. Please advise. Thanks.
Ps: Attached is a MS word to show how the desired update sheet would look like and the file of what I've currently.
kayoke
Bookmarks