Hi All,
I have a workbook with 12 sheets named JAN, FEB, MAR etc.
Each sheet is a Roster sheet that has dates in row 4 starting from F2 being 1, G2 being 2 and so on till AJ2 being 31.
Column C & D have names and staff numbers.
The last row to be used in this code is a merged row in column A that has the text "END OF ROSTERS" (Minus one row).
Attached is a downsized version of the roster.
I need a vba code to do the following:
Bring on an input box and ask to enter a date (anything between 1 to 31).
Based on the entry in the input box choose the correct column from F4 to AJ4 till the row in column A that has the text "END OF ROSTERS" (Minus one row).
Loop the column to find if the cell interior color is RGB(252, 213, 180), if yes, then copy that value along with values in C & D in the same row, loop untill sheet1 has a merged row in column A that has the text "END OF ROSTERS" (Minus one row).
Thank you.