Retrieve Data from one worksheet and place it in another organized by date.

hlaur

New member
Joined
Feb 4, 2019
Messages
7
Reaction score
0
Points
0
Excel Version(s)
2016
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
 
Last edited:
Quite literally any help at all folks. Please. If I'm in the wrong thread just kindly direct me to the right one
 
Back
Top