Forum Discussion
Autopopulate formula across worksheets?
I am trying to create a lunch schedule for the year with approx 30 people. Each day a new person will be chosen (with their initials on Picture 1), and then it will automatically rotate (s...
Sounds like you're rotating lunch duties and want the scheduled date to automatically appear on each person's sheet, even if you swap someone last minute.
One approach:
- On Sheet 2, use a formula like INDEX + MATCH or FILTER to pull the date based on where someone’s initials show up on Sheet 1.
- If initials don’t match full names exactly, set up a helper range to link them.
- If someone’s out and you manually change Sheet 1, the date on Sheet 2 will auto-update too — as long as the formulas are tied to what’s on Sheet 1.