Drop down list to provide me with two additional drop down lists selections....
Thanks for the help in advance
I received some help awhile back on my first problem. This problem was that once I selected a "Tool Type" from a drop down list, it would provide me with the list of "Tools" in the next cell. Once I select one of those tools it would fill in a few other areas with the proper information.
I know to do this I had to have the "Tool_Type" name and the table that the "Tools" were located named the same.
Is there a way that by selecting a certain "Tool_Type" that it will provide me with a drop down list from another table, outside of the "Tools" table? Say I wanted a table that contained "Tool_Holders" that were only used for certain tool types.
Any help would be great!
Re: Drop down list to provide me with two additional drop down lists selections....
Alright that explanation is confusing as all heck. to break it down
My file has a drop down list of "Tool_Types"
I can select a tool type, the next cell below it =Indirect(cell#)
This cell references the tool type to find a tool number, then I select a tool number it fills in about 8 cells below it with the right information.
Below those cells is the cell I referring to. I need this cell to pull from another table, the table is decided by the tool type. How do I do this. I had help with the indirect part the first go around. The way it seems to work is that the cell must have an identical name to the type.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By claire_wilson in forum Excel Programming / VBA / Macros
Last Post: 03-17-2013, 06:59 PM
By betic in forum Excel Formulas & Functions
Last Post: 09-26-2012, 03:47 PM
By Excel_Beginner_1 in forum Excel General
Last Post: 05-15-2012, 03:31 PM
By SCIFINUT in forum Excel Formulas & Functions
Last Post: 02-27-2012, 05:41 PM
By justindbutler87 in forum Excel Programming / VBA / Macros
Last Post: 09-12-2011, 03:27 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1