I have an existing spreadsheet which has product information along with sales information. The sales information is grouped by manufacturer number. My end users want to also see the corresponding sku (i.e. product ID); however there are some manufacturer numbers which have more than 1 sku, so they requested that I provide a drop down list of the corresponding skus for each manufacturer number. To further complicate things the manufacturer number is not necessarily unique across all vendors. To solve this in my original spreadsheet I used a concatenate formula.
I've read a lot of instructions about dependent drop down lists and named ranges; however I'm struggling with finding a simple step by step on how to accomplish what I need done.
My situation differs from many that I've seen in that I only need 1 column of drop downs. My manufacturer number (MFR#) is static and doesn't need a drop down.
Let me know if there are any other questions, I'm pretty new at this.
First spreadsheet is main tab in which I need to have drop downs for skus.
Excel 2013 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
2nd spreadsheet is my 2nd tab from which I would pull the skus
Excel 2013 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
I've read a lot of instructions about dependent drop down lists and named ranges; however I'm struggling with finding a simple step by step on how to accomplish what I need done.
My situation differs from many that I've seen in that I only need 1 column of drop downs. My manufacturer number (MFR#) is static and doesn't need a drop down.
Let me know if there are any other questions, I'm pretty new at this.
First spreadsheet is main tab in which I need to have drop downs for skus.
Excel 2013 32 bit
A | B | C | D | |
|---|---|---|---|---|
1 | Concatenate | Vendor # | MFR # | Sku # |
2 | 8645D93114 | 8645 | D93114 | |
3 | 861184895/OLD#83864 | 8611 | 84895/OLD#83864 | |
4 | 7987RS100AW-BLK | 7987 | RS100AW-BLK | |
5 | 860476068-CHA | 8604 | 76068-CHA | |
6 | 860476893EW-NVBK | 8604 | 76893EW-NVBK | |
7 | 8627G008 /OLD#G8845 | 8627 | G008 /OLD#G8845 | |
8 | 8020B180DST /B18DST | 8020 | B180DST /B18DST | |
9 | 8201THS01-2X | 8201 | THS01-2X | |
10 | 8633402 | 8633 | 402 | |
11 | 861184890/OLD#83865 | 8611 | 84890/OLD#83865 | |
12 | 8020100069-479 DISC | 8020 | 100069-479 DISC | |
13 | 8337RM2035200 MENS | 8337 | RM2035200 MENS | |
14 | 860476887EW-BLK | 8604 | 76887EW-BLK | |
15 | 946840135 ITASCA | 94 | 6840135 ITASCA | |
16 | 860210017424 | 8602 | 10017424 | |
17 | 805T347 | 805 | T347 | |
18 | 8633438 | 8633 | 438 |
<tbody>
</tbody>
| Sheet: All MFR# |
<tbody>
</tbody>
2nd spreadsheet is my 2nd tab from which I would pull the skus
Excel 2013 32 bit
A | B | C | D | |
|---|---|---|---|---|
1 | Concatenate | Vendor # | MFR # | Sku # |
2 | 0000010000 | 0000010000 | 000000001 | |
3 | 0000020000 | 0000020000 | 000000002 | |
4 | 0000030000 | 0000030000 | 000000003 | |
5 | 0000040000 | 0000040000 | 000000004 | |
6 | 0000050000 | 0000050000 | 000000005 | |
7 | 0000060000 | 0000060000 | 000000006 | |
8 | 0000090000 | 0000090000 | 000000009 | |
9 | 0000010000 | 0000010000 | 000000011 | |
10 | 0000020000DEPOSIT .05 | 0000020000 | DEPOSIT .05 | 000000021 |
11 | 0000020000DEPOSIT .30 | 0000020000 | DEPOSIT .30 | 000000022 |
12 | 0000020000DEPOSIT .60 | 0000020000 | DEPOSIT .60 | 000000023 |
13 | 0000020000DEPOSIT 1.20 | 0000020000 | DEPOSIT 1.20 | 000000024 |
14 | 0000020000 | 0000020000 | 000000025 | |
15 | 0000020000DEPOSIT .20 | 0000020000 | DEPOSIT .20 | 000000026 |
16 | 0000020000DEPOSIT 6.00 | 0000020000 | DEPOSIT 6.00 | 000000027 |
17 | 0000020000DEPOSIT 18-PACK | 0000020000 | DEPOSIT 18-PACK | 000000028 |
18 | 0000020000DEPOSIT 30-PACK | 0000020000 | DEPOSIT 30-PACK | 000000029 |
19 | 0000005782 | 0000005782 | 000000032 | |
20 | 0000007390 | 0000007390 | 000000038 | |
21 | 0000007391 | 0000007391 | 000000039 | |
22 | 0000009951SPECIAL ORDER | 0000009951 | SPECIAL ORDER | 000000041 |
23 | 0000000930 | 0000000930 | 000000043 | |
24 | 0000007747 | 0000007747 | 000000047 | |
25 | 0000007110 | 0000007110 | 000000056 | |
26 | 0000009182 | 0000009182 | 000000062 | |
27 | 0000000995995 | 0000000995 | 995 | 000000064 |
28 | 0000000288BATTERY CORE$12 | 0000000288 | BATTERY CORE$12 | 000000288 |
29 | 0000000346 | 0000000346 | 000000346 | |
30 | 0000000352 | 0000000352 | 000000352 | |
31 | 0000000997 | 0000000997 | 000000621 | |
32 | 0000000995 | 0000000995 | 000000995 | |
33 | 0000000997 | 0000000997 | 000000997 | |
34 | 0000000997 | 0000000997 | 000000998 | |
35 | 0000004636 | 0000004636 | 000002839 | |
36 | 0000006666 | 0000006666 | 000006666 | |
37 | 0000007473SPECIAL ORDER | 0000007473 | SPECIAL ORDER | 000007473 |
38 | 0000008868SPECIAL ORDER | 0000008868 | SPECIAL ORDER | 000008868 |
<tbody>
</tbody>
| Sheet: Sku Info |
<tbody>
</tbody>
