Dependent drop down list for large worksheet?

aherzog

New Member
Joined
May 27, 2015
Messages
33
I have a large worksheet with four columns (A, B, C, D) with the titles: Item #, MFG, Model, Qty. There are about a 1000 items in total, which means each of these columns has a 1000 cells each. My goal is to create a second worksheet which is blank but has the same titles. I want a drop down list for each category which are dependent on each other, though only the first three columns will be dependent on each other. For example, the first row says this: Item # (Column A) = 12 (Row 1) ; MFG (Column B) = 43 ; Model (Column C) = Air Duster.

If I choose Item # 12, then I automatically want the MFG - 43 and the Model - Air Duster to show up in their respective columns (kind of like a conditional formatting type situation). Subsequently, if I choose MFG - 43 in Column B, then I automatically want Item # 12 and Model - Air Duster to show up in that same row under their assigned columns.

Is this possible? This is a large spreadsheet with about 1000 items per column. How long would something like this take? And, if what I am looking to accomplish isn't possible, does anyone have any other solutions which may give me similar results? Thanks.
 
Sorry about the yellow lines, I was testing the "Duplicate" data.!!!
The idea was that that you wanted to select "MFG" numbers from sheet1, as required and place the selected items with there related data on sheet2.
Thats what the userform does. You click the Userform Button, a List from sheet1 appears, you select an Item "Click ADD" and that "MFG" number with its relted data appears in the list in sheet2, You can add as many "MFG" numbers as you like. When you want to delete that list "Click" "Delete Data".
In the majority of cases there is only one instance of the "MFG" number, but occasionally ther is more than one instance, In those cases , when you select the "MFG" number all the related Instances will be displayed.
This userform selection method was just my idea of something you might be able to use. Perhaps not!!!!!
 
Last edited:
Upvote 0

Forum statistics

Threads
1,226,892
Messages
6,193,538
Members
453,806
Latest member
Gene Michaels

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top