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:D10, 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