S
Steve Jones
Hi
In one worksheet I have list of Suppliers and their addresses.
In another worksheet I have a stock list (Column A - Supplier, B - Stock
Description, C - Unit & D - price)
In the third worksheet I have dropdown list of suppliers in cell A1, with a
lookup which drops the addrsss details in a2 through a5.
I would like from referencing cell A1 (Supplier name), for some way to
lookup the stock list workheet and drop in A10
10, 11, 12 etc a list of all
the stock we buy from that Supplier whether it be one item or 50 items.
Is this possible?
Thanks very much
Steve
In one worksheet I have list of Suppliers and their addresses.
In another worksheet I have a stock list (Column A - Supplier, B - Stock
Description, C - Unit & D - price)
In the third worksheet I have dropdown list of suppliers in cell A1, with a
lookup which drops the addrsss details in a2 through a5.
I would like from referencing cell A1 (Supplier name), for some way to
lookup the stock list workheet and drop in A10
10, 11, 12 etc a list of allthe stock we buy from that Supplier whether it be one item or 50 items.
Is this possible?
Thanks very much
Steve