unhorsedpenny
New Member
- Joined
- Nov 23, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am looking to create a formula that takes the day of the week and calls for a specific sheet.
IE If it's Monday it takes the table from Sheet 2, if it's Tuesday it takes the table from Sheet 3 etc
For background I am creating a sheet for a schedule, if it's Monday then do this task, if it's Tuesday do this task etc. I have the tasks as separate sheets
IE If it's Monday it takes the table from Sheet 2, if it's Tuesday it takes the table from Sheet 3 etc
For background I am creating a sheet for a schedule, if it's Monday then do this task, if it's Tuesday do this task etc. I have the tasks as separate sheets