I am trying to build a spreadsheet for work. See link.
Looking for “New Client” Button. When I click this it will ask what pattern I want to use (Pattern 1,2,3,4). When I choose the pattern it will give me 5 times, one for each day in the pattern and will populate these times with the clients name. I need the client to stay in these times in this pattern for 4 weeks. After 4 weeks I need the clients name to be moved to the next pattern ie Pattern 2, client given another 5 times in the new pattern and populate the new times with clients name. After another 4 weeks this happens again, moves onto next pattern ie pattern 3 etc.
I need this to happen continuously moving client from pattern to pattern every 4 weeks after reaching pattern 4 it goes back to pattern 1.
I have to say that the client may not start in pattern 1 but I need them to move through the patterns until they have been removed from the spreadsheet.
I hope this makes sense.