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!
Welcome to the forum.
There are instructions at the top of the page explaining how to attach your sample workbook.
Administrative Note:
Please update your forum profile with the version of Excel that you are using.
Also, although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks