Macro to add new date entries to existing records in database
Hello,
Would someone please help me design a relatively simple macro? I have a database of approximately 30,000 employees, listed by badge #. Some of the employees are occasionally run through assessments, which then requires my team to add the new assessment dates to their records. The fields to track the assessment dates are already in place.
See sample worksheet (attached), which gives the basic idea for the functionality I’d like.
The macro would:
1. Read the badge # and the Assessment Type from the “Dates to add” table
2. Find the matching Badge # in the database and paste the new Assessment Date into the correct column
…unless you have a better idea to update the database! I'm all ears.
Help greatly appreciated!
|