Forum Discussion
Pulling data using drop downs
Hello,
This may not be possible, but can you input 'Consultant' and 'Month' in the below and it will auto generate the active, completed and closed columns.
and it will then be able to pull the data automatically from the below spreadsheet? Using columns A,B and G?
So each month i could go into the top sheet and change the consultant and month and it will give me that months overview?
Thanks so much
Like this?
Yes, that can be done.
Without seeing the actual workbook, it would be hazardous to venture to write the exact formula. But the FILTER function is one way that could be done. If you're comfortable playing with Excel, here's a reference that explains the FILTER function. If you're not, come back and post a copy of the actual workbook, not just images, with enough data filled in (fake names and so on) to be a real "test case."
- Thank you.
Pretty new to all this, i think i've made a link and it will be shareable, there is no important data in there.
https://docs.google.com/spreadsheets/d/1x_LYOXuB6k9VOSa-ZZGDK_q1jWlxPsAW/edit?usp=drivesdk&ouid=117707044031102458887&rtpof=true&sd=true
Thanks againDoes this do what you want?
