I will post in a new Thread since it's a different question.
I am trying to get sheet1 of this spreadsheet to auto fill from reference data on sheet 2.
Rules are: 1- each user has 5 entries per day
2-Entries auto fill per the scheduled work days
3- 2 last entries for each user/day will be tagged Extra (currently doing manually with =MOD(ROW(),4)=0, then sorting by formatting color and adding the text)
4- I would like to be able to add a user in the Reference Data and have it show up in the first sheet completely configured
sheet 2 has the reference data for the users
Screenshot 2023-05-23 121104.jpg
I'm looking to build sheet 1 automatically from date1 to date2. Each user has 5 entries they can add per day, with days they don't work.
Screenshot 2023-05-25 110328.jpg
The Xlookups are easy, but how do i get it to build itself with the days marked in x as working days, and make sure it repeats 5 times for every user and every day?
Bookmarks