I am trying to automate my payroll process and would like to get your help on how this can be accomplished.
Right now, we do daily reconciliations and each workbook contains a simple table with the employees name in the header and their total in the bottom row. The workbook name is based on date ie "05.01.18"
In the pay summary workbook, i do i a hlookup based on the name match and return the total for that day.
But every 2 weeks, I have to go into each cell and edit the link to match the date so it will pull the correct total for that day.
Is there a way this process could be automated? I am familiar with VBA and would not mind a VB based solution but would rather use Excel formula's if possible.