Need dynamic functionality using dropdown boxes in google sheets
Hello all, and Happy Friday!!
I've been trying to build a useful spreadsheet for a client in Google Sheets that requires three functions I am having difficulty with, and they are so linked together, I am afraid to post them as separate questions. Here goes:
1) I would like to automatically export data from only one tab (Tab D) of a multi-tabbed daily spreadsheet into one separate new monthly summary spreadsheet. (Outcome: all data from tab 'D' from all (m-f) daily reports appears in a new single summary of that tab for the entire month. So my daily reports have tabs a, b, c, and D, but we get to see a whole months worth of 'tab D' in its own separate monthly report.)
2) In a separate tab in this new monthly summary report, rather than listing the litany of measurements we've made that month and have a clunky, crowded spreadsheet, I would like to include a drop-down menu that indicates different criteria, and when that items is selected, that function is executed. I've attached a small sample of what I mean. And lastly,
3) I would like a chart accompanying that selection to appear when selected, if possible. So in the example I attached, when I click on 'Brand New Member - Did Not Work Out' my desired outcome is that the number of members who signed up for the gym but did not work out would be displayed (that data lives on another tab in this same report) AND that the chart/visual for that data ALSO appears when that item is selected from that drop-down menu...
If Excel is the way to go for this I am game, but for now, I'm trying to use google sheets. I hope I have explained this clearly--any/all assistance will be greatly appreciated!!
Thanks!
Michael
Instead-of-this_.gsheet
I-m-hoping-for-this_.gsheet
I've been trying to build a useful spreadsheet for a client in Google Sheets that requires three functions I am having difficulty with, and they are so linked together, I am afraid to post them as separate questions. Here goes:
1) I would like to automatically export data from only one tab (Tab D) of a multi-tabbed daily spreadsheet into one separate new monthly summary spreadsheet. (Outcome: all data from tab 'D' from all (m-f) daily reports appears in a new single summary of that tab for the entire month. So my daily reports have tabs a, b, c, and D, but we get to see a whole months worth of 'tab D' in its own separate monthly report.)
2) In a separate tab in this new monthly summary report, rather than listing the litany of measurements we've made that month and have a clunky, crowded spreadsheet, I would like to include a drop-down menu that indicates different criteria, and when that items is selected, that function is executed. I've attached a small sample of what I mean. And lastly,
3) I would like a chart accompanying that selection to appear when selected, if possible. So in the example I attached, when I click on 'Brand New Member - Did Not Work Out' my desired outcome is that the number of members who signed up for the gym but did not work out would be displayed (that data lives on another tab in this same report) AND that the chart/visual for that data ALSO appears when that item is selected from that drop-down menu...
If Excel is the way to go for this I am game, but for now, I'm trying to use google sheets. I hope I have explained this clearly--any/all assistance will be greatly appreciated!!
Thanks!
Michael
Instead-of-this_.gsheet
I-m-hoping-for-this_.gsheet
Koen
cannot open your attachments, please provide a sample data set (in excel)
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.