Hi there.
I'm trying to automate alot of my office workflow. I currently receive timesheets that then have to be entered into a cost control document. I have to go through each person and insert their hours worked (days & downtime) on the cost document under the relevant date. Depending on how many guys are working, it can take me over a day doing data entry!
Does anyone have any VBA code they are willing to share that could automate this process? I was thinking of a macro on the timesheet template, as the location of the cost document will never change. I've tried a few snippets of code I've found on other forums, but I simply can't get anything to work. The dates going across in a row on the cost sheet stumped me the most!
I've created an example timesheet and cost sheet in the format we currently use. Unfortunately, changing the format at this time isn't an option so hopefully some clever code could be implemented! Examples: https://drive.google.com/drive/folders/12RhJuLUNf-CKJoRua1gmRQyGW1ilTKkW?usp=sharing
Thanks in advance!
I'm trying to automate alot of my office workflow. I currently receive timesheets that then have to be entered into a cost control document. I have to go through each person and insert their hours worked (days & downtime) on the cost document under the relevant date. Depending on how many guys are working, it can take me over a day doing data entry!
Does anyone have any VBA code they are willing to share that could automate this process? I was thinking of a macro on the timesheet template, as the location of the cost document will never change. I've tried a few snippets of code I've found on other forums, but I simply can't get anything to work. The dates going across in a row on the cost sheet stumped me the most!
I've created an example timesheet and cost sheet in the format we currently use. Unfortunately, changing the format at this time isn't an option so hopefully some clever code could be implemented! Examples: https://drive.google.com/drive/folders/12RhJuLUNf-CKJoRua1gmRQyGW1ilTKkW?usp=sharing
Thanks in advance!