I would need some assistance with writing 2 VBA scripts. I have created a dummy data set for visual support that can be found below.
Script 1: Counting subsequent days and inputting the results in a column
In the Start sheet, I am attempting to fill the column D(Subsequent days) with text values indicating how many subsequent days an employee has worked.
The script has to answer the following objectives:
Skip the rows with no employee names
Duplicates the text values in duplicate rows (see example)
Format the values as following: "1 day"or "2 days" or "3 days"..etc
Script 2: Counting and highlighting the cells that answer a particular condition
In the Summary sheet, I need to come up with a script that will highlight the cells in the Department column that have 2 or more employees that worked 2 or more days. I also need to count the number of departments that answers that condition and place the result in cell K1. (see example)