I have a worksheet set up with dates(merged cells) and departments(two separate cells) on the top and names on the side like this:
06/01-03 06/04-10 06/11-17
Ship Main Ship Main Ship Main
Bob
Jim
Lisa
Bill
Now I have another sheet that someone puts in the date and the name and the department, and hours worked in that department.
My question is, how do I (1) Get the date in the right column if it falls in or on the start or end date, then
(2)how do I get it to be in the shipping or maintenance column.
06/01-03 06/04-10 06/11-17
Ship Main Ship Main Ship Main
Bob
Jim
Lisa
Bill
Now I have another sheet that someone puts in the date and the name and the department, and hours worked in that department.
My question is, how do I (1) Get the date in the right column if it falls in or on the start or end date, then
(2)how do I get it to be in the shipping or maintenance column.