Trying to autofill a schedule

[aferland]

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?

[AliGW]

Except it is NOT a different question - it's the same question with more specific requirements.

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...h-formula.html

I have copied your post to the earlier thread.