tanyacook
New Member
- Joined
- Jul 18, 2024
- Messages
- 1
- Office Version
- Prefer Not To Say
- Platform
- Windows
- MacOS
HI!
I am trying this in Google sheets firstly but would like to see if it's possible as it needs to be a shared doc.
I'd like to collate information from dropdown menus from different sheets all into one sheet.
Say the people are being accepted or declined in a club. If I change the accepted or declined option in the drop down menu of the various sheets within the workbook, how do I collate JUST the accepted applicants into one sheet (whilst still including the whole row of data rather than just the cells saying accepted).
Here is an example of ideally what I'm aiming for...
Accepted list from collated data from Groups A, B and C
Data in 3 separate sheets - Groups A B and C
Many thanks for all of your help!
Tanya
I am trying this in Google sheets firstly but would like to see if it's possible as it needs to be a shared doc.
I'd like to collate information from dropdown menus from different sheets all into one sheet.
Say the people are being accepted or declined in a club. If I change the accepted or declined option in the drop down menu of the various sheets within the workbook, how do I collate JUST the accepted applicants into one sheet (whilst still including the whole row of data rather than just the cells saying accepted).
Here is an example of ideally what I'm aiming for...
Accepted list from collated data from Groups A, B and C
Data in 3 separate sheets - Groups A B and C
Many thanks for all of your help!
Tanya
