I created a dropdown box and would like the all the data to fill in automatically based on which dropdown selection is picked. I need a little guidance on how to complete this task easily.
Thanks!
I created a dropdown box and would like the all the data to fill in automatically based on which dropdown selection is picked. I need a little guidance on how to complete this task easily.
Thanks!
Hi and welcome to the forum
Try this, copied down...
=INDEX($A$1:$M$14,ROW(),MATCH($R$1,$A$1:$M$1,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi ggummo
Try this Code in the Worksheet Module![]()
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thank you!! This forum is going to be a life saver, because the one thing I can not master in Excel are the forumulas!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks