Hi again!

I have to emphasize, that when defining the named range CatSuppl, you must
activate cell Data!B2 (really any cell in 2nd row of any sheet, but it will
be easier this way tu understand the logic). And be careful to leave row
reference in Data!$A2 relative - the named range CatSuppl is dynamic in 2
different ways, it depends on category value on same row in sheet Data, and
on number of suppliers in according Category column in Suppliers sheet.


And there was a typo in Categories named range definition. It must be
Categories=OFFSET(Suppliers!$B$1,,,1,COUNTA(Suppli ers!$B$1:$AX$1))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )