Forum Discussion
Nicky Sehgal
Jan 31, 2018Copper Contributor
How to create a data column that changes with dropdown box menu
Hey all
really struggling to find out how to create a data column that can change with a dropdown menu, can any one help
I download a template which does it but cant make heads or tails...
Mark Fitzgerald
Feb 01, 2018Iron Contributor
I downloaded the template and, after unprotecting the Financial Report sheet, could see that SelectedYear drop-down was a list sourced from the lstYears range. lstYears is a convoluted dynamic range (i.e. it uses the OFFSET function to define itself) which boils down to C5:I5 on the Financial Data Input sheet. Why they didn't just define the range name directly is beyond me!
If you change the headings in lstYears to month names the SelectedYear drop-down will let you choose from the month names.
You may want to change the range names to lstMonths and SelectedMonth to eliminate confusion.
- Nicky SehgalFeb 02, 2018Copper Contributor
thank you i have cracked it