Hello All.
I have a shift, that only works Saturday thru Monday (3 Days)
I have:
Where G2 and H2 are start and end times of 5:00:00 AM & 4:00:00PM respectively, and on the same day (not crossing midnight into the next day)
Where G4 is data I wish to select
AND
Where Column A is Date Format of xx/xx/xxxx and column S is the day format of "ddd" from above code.
The problem, is finding the data of column G on the specific days of Saturday, Sunday, and Monday, using the Shift Times in G2 & H2.
Can someone lead me in the right direction please
Thank you
I have a shift, that only works Saturday thru Monday (3 Days)
I have:
VBA Code:
Range("T3").Select
ActiveCell.FormulaR1C1 = "3rd Shift Actual Wt."
Range("T4").Select
ActiveCell.Formula = "=IF(AND($B4>=$G$2,$B4<=$H$2),$G4,"""")"
Selection.AutoFill Destination:=Range("T4:T" & Range("A" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select
Where G2 and H2 are start and end times of 5:00:00 AM & 4:00:00PM respectively, and on the same day (not crossing midnight into the next day)
Where G4 is data I wish to select
AND
Code:
'Add Day of Week
Range("S3").Select
ActiveCell.FormulaR1C1 = "Day of Week"
Range("S4").Select
ActiveCell.Formula = "=IF(A4<>"""",TEXT($A4,""ddd""),"""")"
Selection.AutoFill Destination:=Range("S4:S" & Range("A" & Rows.Count).End(xlUp).Row)
Range(Selection, Selection.End(xlDown)).Select
Where Column A is Date Format of xx/xx/xxxx and column S is the day format of "ddd" from above code.
The problem, is finding the data of column G on the specific days of Saturday, Sunday, and Monday, using the Shift Times in G2 & H2.
Can someone lead me in the right direction please
Thank you