Hello,
I am very new to VBA, so thanks in advance for your patience.
I have attached a file where all Work Order info is inputted into a log in Sheet1. Sheet2 is an employee timesheet.
I want to autopopulate the employee timesheet with the information from every new work order that is inputted into the log.
I understand how to do this through the use of IF, VLOOKUP, and WEEKDAY functions in the cells themselves, but this leaves a lot of blank rows on the timesheet, therefore I would like to avoid this by using VBA.
Essentially, this is what I want the program to do:
If Date Completed in Sheet1 is a Monday, then
Extract Work Order #, Description, Time Started and Time Completed from that same row in Sheet1
And place them in the first blank row under the Monday category in Sheet2
Any help or hints at all would be greatly appreciated.
Thanks!
View attachment excelhelp.xlsx
I am very new to VBA, so thanks in advance for your patience.
I have attached a file where all Work Order info is inputted into a log in Sheet1. Sheet2 is an employee timesheet.
I want to autopopulate the employee timesheet with the information from every new work order that is inputted into the log.
I understand how to do this through the use of IF, VLOOKUP, and WEEKDAY functions in the cells themselves, but this leaves a lot of blank rows on the timesheet, therefore I would like to avoid this by using VBA.
Essentially, this is what I want the program to do:
If Date Completed in Sheet1 is a Monday, then
Extract Work Order #, Description, Time Started and Time Completed from that same row in Sheet1
And place them in the first blank row under the Monday category in Sheet2
Any help or hints at all would be greatly appreciated.
Thanks!
View attachment excelhelp.xlsx
Last edited: