snowfroguk
10-14-2015, 08:44 AM
Hi,
I need a relatively complicated (for me!) VBA code to do the following:
We have a master spreadsheet which has all of our current employees and their salary and grade in each month. I need to clarify each quarter that their salary and grade for each month is the same, and pull through the amended salary / grade if it is not.
Unfortunately this means that I have to check the salary / grade columns for each month against a spreadsheet for that month (going back to the beginning of the year in every instance, in case of backdated changes).
I have written the VBA which pulls through all of the current data for the months to different spreadsheets in each tab and saves the workbook, but I now need to automatically:
- Pull through new employees who were not already in the spreadsheet (so any employee who appears in any of the individual month worksheets but not in the master)
- Check salaries and grades for each month column against the relevant month worksheet and overwrite if different
- Highlight in a different colour any changes that have been made in order to spot check grade changes for legacy rights
- Set salary / grade to 'N/A' in months where the employees hadn't started (i.e. the vlookup throws up an #N/A)
I hope that makes sense, I've tried doing bits and pieces, but I'm fairly new to VBA, and my brain is turning to mush!
Thanks very much
I need a relatively complicated (for me!) VBA code to do the following:
We have a master spreadsheet which has all of our current employees and their salary and grade in each month. I need to clarify each quarter that their salary and grade for each month is the same, and pull through the amended salary / grade if it is not.
Unfortunately this means that I have to check the salary / grade columns for each month against a spreadsheet for that month (going back to the beginning of the year in every instance, in case of backdated changes).
I have written the VBA which pulls through all of the current data for the months to different spreadsheets in each tab and saves the workbook, but I now need to automatically:
- Pull through new employees who were not already in the spreadsheet (so any employee who appears in any of the individual month worksheets but not in the master)
- Check salaries and grades for each month column against the relevant month worksheet and overwrite if different
- Highlight in a different colour any changes that have been made in order to spot check grade changes for legacy rights
- Set salary / grade to 'N/A' in months where the employees hadn't started (i.e. the vlookup throws up an #N/A)
I hope that makes sense, I've tried doing bits and pieces, but I'm fairly new to VBA, and my brain is turning to mush!
Thanks very much