Drop Down Lists so that different sets of data are pulled in when a value is selected
Hi all,
I'm trying to build a spreadsheet whereby different sheets in the same workbook relate to different fund ranges and then on the main spread sheet a user can select the required one and the data would refresh to show the info required from the relevant sheet. If anyone has any ideas on the best way to do this, it would be much appreciated.
Many thanks,
Fajr
Hi,
Check out Debra's site here http://www.contextures.com/xlDataVal15.html where you'll find everything you ever need to know on this subject - and more.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thank you, Richard. I'm still trying to figure out how to link a set of info to each item in the list. So say I choose Fund A from the drop down list- how do I make such that charts and figures related only to that Fund show on that sheet?
Attached is a template for a summary worksheet with a dropdown menu to import data from different worksheets in the file. Please respond if this is inadequate or confusing.
This is perfect, thank you!
The written example referenced by Richard Buttrey takes one just into the second column and leaves one guessing as to how to proceed. The downloadable file takes it further though you will find a number of "holes" in the data that haven't been filled in. It does however give a good idea on how to proceed from there.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks