I am the person that will be helping you today. May I take a look at the document you need help with so that I can complete this task for you?
Please, be forewarned that the site is not secure:- Click the following link: http://www.wikisend.com- Upload the file to that website- Once it is uploaded, the resulting page will display a "File ID" number.- Please, give me that "File ID Number" I will be standing by.
Thank you. I will start working on this.
Thank you for the update.
I am looking at the sheet now. Please, explain what you need for this document to do.
I honestly, do not understand. You wish to choose one of the values in the dropdown box and have the resulting items that match, be entered into the 2nd sheet?
I got it. Thank you for the clarification. I will have this fixed and uploaded soon.
Do you need a macro of some sort to be setup for this or do you just need me to gather the values as you described and create the sheet for you?
You wish to have this done in A6 to G6, correct?
I have run out of ideas.
For this reason, I am opting out of the question and allowing another expert the chance to help.
The next expert will see all that is on this page, so there will be no need to repeat anything.
When another expert picks this up, you will be notified by email.
Thank you for your patience.
hello, I will be helping you with this.
Just so I understand you want to have multiple drop downs, one that lists the values for each of the unique values in column A. Is this correct?
Also I will need to know which version of excel you are running
can you tell me which version of excel you are using?
ok, then a macro will work.
You should understand the following.
1. There is no formula that will do this. The way data validation lists work is by using a range of cells with values.
2. A macro can be used to sort and filter this data into several lists and then create the drop downs for you.
3. The macro can be put in so that every time you open the workbook it runs for you and updates the lists incase you add more data. or a button can be added that you push
to update the data.
4. There will be an additional fee to create such a macro.
Does this sound agreeable?
a vlookup would not work as it would only give you the first value that matches.
So the macro would create separate lists for all the values matching each letter. Instead of only the first result that vlookup would do. The macro could also create the data validation lists themselves from those lists.
Think of it like having a bucket with different colored golf balls in it. THe macro would separate all of the red balls into a list, and all of the blue ones, and green ones, and so on.
unfortunately you are going to have the same problem. You will still need a macro to filter out the blanks.
You can sort all the columns By descending values before doing the lists, but some lists will still have blanks in the middle.
This was listed as a programming question. I suggest you strongly consider the macro, it will make things easier in the long run
sorry, a formula willl not get rid of the blanks.
Not sure what you saw on some website, but there is a lot out there that is incorrect. As I said the formula would only return the first result, not all of them.
It is possible to eliminate the blanks by sorting the column, in essence putting all of the blanks at the bottom.
do you have something about macros. Again much easier.
sorry, a macro is so much more. It can actually program any function that you could do manually. Like copying and pasting all of the values into separate columns and generating drop downs from that.
I just don't see a formula working in this case.
The only thing with a macro is they don't run on MAC os. And some security settings in excel make it so you have to press a button at the top of the screen to enable macros when you open the document. Other than that the macro would be programmed to run when the workbook is opened. So other than enabling macros the person you give it to would not have to do anything else.
You asked for my expertise and I have been working with excel for over 20 years and know all the ins and outs. I do sometimes feel that macros will work in some circumstances where formulas will not.
you can view the code for the macro, but I am not sure you will understand it. Just know that the macro can do what you were looking for.