pmcgrath92
New Member
- Joined
- Jul 24, 2014
- Messages
- 26
Hi Everyone,
I want to create a dynamic "to-do" list in a main/front sheet, which is based upon cell value from data validation in multiple other sheets. Let's say I have sheets A and B - which each have a list of objectives and a "Status" (e.g. Unactioned/In Progress) based on Data Validation. Then there is a main sheet/to-do list, which looks at the status of objectives across ALL sheets (in this case, A and B); subsequently listing them all objectives in a dynamic fashion. Some pictures as examples below:
Sheet A - with the list of Task/Objectives in Column C; and Status in Column E.
Sheet B - same layout as Sheet A
TO-DO Sheet - Which lists all of the Unactioned and In Progress tasks from Sheets A and B underneath.
I.e. in Sheet TO DO I would like B3:B6 (or longer) to list all of Sheet A C6:C11 and Sheet B C6:C9 based on Sheet A E6:E11 and Sheet B E6:E9 = "Unactioned"
(& then the same from TO DO B12:14 but based on the Status = "In Progress").
I hope that's a good enough explanation, but happy to provide any more details.
Thanks in advance!
Paul
I want to create a dynamic "to-do" list in a main/front sheet, which is based upon cell value from data validation in multiple other sheets. Let's say I have sheets A and B - which each have a list of objectives and a "Status" (e.g. Unactioned/In Progress) based on Data Validation. Then there is a main sheet/to-do list, which looks at the status of objectives across ALL sheets (in this case, A and B); subsequently listing them all objectives in a dynamic fashion. Some pictures as examples below:
Sheet A - with the list of Task/Objectives in Column C; and Status in Column E.
Sheet B - same layout as Sheet A
TO-DO Sheet - Which lists all of the Unactioned and In Progress tasks from Sheets A and B underneath.
I.e. in Sheet TO DO I would like B3:B6 (or longer) to list all of Sheet A C6:C11 and Sheet B C6:C9 based on Sheet A E6:E11 and Sheet B E6:E9 = "Unactioned"
(& then the same from TO DO B12:14 but based on the Status = "In Progress").
I hope that's a good enough explanation, but happy to provide any more details.
Thanks in advance!
Paul