Dependent drop down list for large worksheet?

[aherzog]

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.

 

[MickG]

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!!!!!