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 t...
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?
Thank you so much for this Hans.
Do you know the formula you used? As in hindsight it may be easier if I just had all the names already on there and just had to update the month. Like below;I tried dragging down each column thinking the formula would carry over but no luck.
