Hey,
I'm wondering if anyone would be able to help me with a macro, it's been bugging me for weeks and manually doing this would take me forever.
Step 1) Match a name from Column A in AMOStaffList to a name in Column F In MDPData
Step 2) If a match IS found go to Step 3, if a Match is NOT found go to Step 1 and continue searching.
Step 3) Check the date on the matched row from Column BW in AMOStaffList to the left 10 characters of the date in Column D in MDPData
Step 4) If a Match IS found go to Step 5, If a match is NOT found go to step 1 and continue searching.
Step 5) Using the matched rows change the Value of Column BY and Column BZ in AMOStaffList to the values from Column H and Column I in MDPData
Note: In this example I have manually filled in the data in Column BY and BZ, normally these cells would be empty. In my main document the AMOStaffList is much larger so is the MDPData file.
I would much appreciate some help with this.
Best Regards
Hyflex
Bookmarks