Hi,
I want to create a Drop Down and a Dependent Drop down with the source data for each drop down on a different sheet (same workbook).
When I do this, I cannot get the INDIRECT function to work. I'm 99% sure it's a reference thing, but for the life of me, I cannot get this to work.
Can anyone assist or explain how to do it? I've attached a small example where it works if source data is on Sheet1, but not on Sheet2.
Any help greatly received. Thank you!
Staffs Lebowski..
1. Create named ranges for fruits and veg from sheet 2
2. for the dependent, use List, then...
=INDIRECT(D$3)
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
Thank you, that worked perfectly!
Happy to help
Dear FDibbins, Can you just help be with the same problem
My parent drop down is in column G; dependent drop down is in column L. and it doesn't work.
Hi Mohamud Abdisamadm,
Kindly create new thread showing requirement, make sure you attach a sample file without sensitive information, so you question will be sure answered.
Punnam
Thank you Punnam
I have create a dependent drop downs. the parent list is in column G, the dependent list is in column K. however, the list evaluates an error.
Last edited by Mohamud Abdisamad; 05-18-2020 at 03:02 AM.
Hello. you are still in the same thread which belongs to another one. Try to open a NEW thread. for your own question.Originally Posted by Mohamud Abdisamad
Quang PT
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks