Good evening,
I'm working on a task spreadsheet that has 10 tabs, each tab has 2 columns. For the sake of simplicity let's say column A has the task description and column B has the task due date. I want to create a tab at the very beginning that has a calendar. When a user chooses a date from within that calendar I would like for that tab to populate with tasks from all 10 tabs that have a due date of that chosen date. I would like for the task description to also populate. Any help is greatly appreciated. Thank you!
I'm working on a task spreadsheet that has 10 tabs, each tab has 2 columns. For the sake of simplicity let's say column A has the task description and column B has the task due date. I want to create a tab at the very beginning that has a calendar. When a user chooses a date from within that calendar I would like for that tab to populate with tasks from all 10 tabs that have a due date of that chosen date. I would like for the task description to also populate. Any help is greatly appreciated. Thank you!