Hi-
To monitor budget vs actuals on Salary, I need to update on a monthly basis our Actuals vs Budget file based on Payroll info. I'm using vlookup but consumes a lot of manual input since I need to update about 200 staff monthly salary info re: salary, overtime, and benefits. Pls help.
I've attached a sample of the two files.
In the original files, there are multiple cost centres for all staff (>300). Sample file only presented a few staff with 1 staff referenced in the Salary Input file.
Last edited by carlos.delossantos; 06-15-2015 at 02:23 PM.
What are you waning to do? I don't see a specific question.
The CTS is my working file that needs to be updated from the Salary information generated every month (the Salary Input file).
There are at least 300+ staff in the original file (sample file is parsed) and each staff salary info has to be updated from the Salary input.
Data to be updated are about 7 or 10 fields, from Salary, hours, overtime hours, other earnings, and benefits. So the vlookup tool is required for accuracy but the process is very repetitive to update the 300+ staff salary information every month.
This could be simplified by VBA so I posted my query and would appreciate very much your help.
Thanks.
Carlos
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks