Drop down lists that are dynamic like that would need to be created on the sheet somewhere, perhaps in a hidden sheet. You can have a dynamic named range watching the section of formulas creating the list for you from your chosen "category" and providing the drop down functionality.
If you describe your data set in detail or post an adequate sampling of the data the formulae would need to incorporate, we can offer many possible ways to get this dynamic list created.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Alright, here is my example of what I am trying to do. The 'Cost Per Pound' sheet contains the data (highlighted in green) that is being pulled from the query on the 'Current Inventory' sheet. I have bolded the fields that I want the drop down lists to work with (just the one column, Lot Numbers). Let me know if you have any problems viewing this or if I need to give you any more information. Thanks for the fast response, I appreciate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks