strawberry1972
Board Regular
- Joined
- Oct 28, 2004
- Messages
- 56
Looking to automate a spreadsheet that generates family meals for a fortnight at a time. I have one long list in a column of the dishes that we like and in the next column whether they are meat, fish, chicken or veg.
What I want to do is for the two weeks (Sunday to the Saturday) come up with a varied menu so that each week we have a balance of the meat, fish, chicken and veg dishes and with no repetitions.
Could someone let me know how best to do this please. I don't really have anything of value to post up so any suggested formats would be considered.
Thanks
What I want to do is for the two weeks (Sunday to the Saturday) come up with a varied menu so that each week we have a balance of the meat, fish, chicken and veg dishes and with no repetitions.
Could someone let me know how best to do this please. I don't really have anything of value to post up so any suggested formats would be considered.
Thanks