Bruno_x
Active Member
- Joined
- Feb 17, 2002
- Messages
- 491
I am trying to know what AutoFilter is used in Column B. I want to use this "value" to make a selection in a list of contact persons (cell B3) in a fax-sheet.
Regards,
Bruno
Regards,
Bruno
MrExcel - selectie leverancier.xls | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | Supplier | ||||||||
3 | Attn. | ||||||||
4 | |||||||||
5 | |||||||||
6 | Ref | Suppl | Date | Weight | |||||
7 | A15 | AMEX | 1/okt | 1500 | |||||
8 | D16 | AMEX | 3/okt | 9820 | |||||
9 | D18 | AMEX | 8/okt | 7800 | |||||
10 | K4 | BOEST | 2/okt | 5110 | |||||
11 | G9 | BOEST | 20/okt | 3260 | |||||
12 | |||||||||
Blad1 |