Dear all,
Is there any possible ways to extract all results from a drop down list?
For example, in my drop down, there are 10 lists which generates 10 results. I want to generate all the results into other cells.
If I select A, "A" result displays in row 1
If I select B, "B" result displays in row 2, in row 1 still display the "A" result.
Kind regards,
Sarin
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
To add a file to a new post
To add a file to an existing post.
Short answer - directly from your DD - no. A DD puts data into a cell in the exact same way as if you had typed it in. All it does is help you enter the data, to avoid typo's and maybe restrict what you can enter.Is there any possible ways to extract all results from a drop down list?
For example, in my drop down, there are 10 lists which generates 10 results. I want to generate all the results into other cells.
However, you could probably use the list that the DD uses, to extract the data you want
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 All,
I want to attach a sample worksheet, but I can't. When I go to manage attachments, I can only upload and cannot proceed to attach in the reply.
Here I attached as picture instead.example.PNG
Kind regards,
Sarin
Just to make sure I understand you correctly...When I change from location 1 to location 2, the result for location 1, which is in cell L1810:N1810 keep the same.
You want to select Loc 1, and have results shown in L1810:N1810
Then you want to select Loc 2, but the results in L1810:N1810 stay unchanged?
Sure, and the Loc 2 result will be generated in L1811:N1811. The same for the rest of Loc
You want to select Loc 1 and then Loc 2 in the same cell, and L1810:N1810 remain unchanged, still showing Loc 1?
What I want is this, it is weird and maybe not possible.
1- If I select Loc 1, result Loc 1 is shown in L1820:N1810
2- If I select Loc 2, result Loc 1 is still shown in L1820:N1810 and result Loc 2 is shown in L1811:N1811
3- If I select Loc 3, result Loc 1 is still shown in L1820:N1810 and result Loc 2 is still shown in L1811:N1811 and result Loc 3 is shown in L1812:N1812
.....
And you are selecting Loc 1 in C1813 - and want an answer shown in L1820:N1820 (I presume that was a typo from you?)
then you select loc 2 in C1813 and you want L1820:N1820 top remain unchanged, but L1821:N1821 now show something
then you again want to change C1813 and now the 1st 2 rows stay the same, but the 3rd row changes?
If that is what you are describing, then no, that is not possible with formulas, but can probably be done with VBA (coding)
Yes, that's exactly I want.
If I use simple Vlookup, the result shows in the highlighted areas only respective to the cell C1813.
My idea is, I want to draw a comparison chart (Loc 1, Loc 2, .... Loc 10). But since I used drop down, I can only get 1 result at a time
Did you read my last line of comment in post #9?
besides, you have LOTS of matches for the different Locs...
163 Location 1
191 Location 2
197 Location 3
169 Location 4
196 Location 5
182 Location 6
178 Location 7
169 Location 8
180 Location 9
175 Location 10
Can you help me with the VBA?
Kind regards,
Sarin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks