Hi


"Chantelle" wrote in message
...
Thanks Arvi,

I have created a sheet suppliers and completed the first step, but then I
am
confused by the following

a)IF formula - where does this go exactly in A2 exactly & why as this is
an
example of waht my spreadsheet looks like.

The formula goes into cell A2 on sheet Suppliers and you copy it down at
least for as much rows as max number of suppliers in any category. It
enumerates rows with at least one supplier in, so you enter only suppliers
into columns starting from column B - the column A is calculated
automatically. NB!. Categories start from column B, Column A is reserved for
a counter (in my example it has header No) - without it named range
definitions wii be much more complex.



Col A Col B
Col C
1 Alcohol Dairy
Dry Goods
2 Dromana Cellars Calender Cheese Fastrac
3 Imports of France Fastrac
Imports
of France
4 Peninsula Dairies
The Essential Ingredient

b) The define name range is this in Insert/Name/Define and then input this
formula section? and the Suppliers!$B$1,,1,is that picking up the
information
in my A1 above?

Exactly! And the named range returns the list of categories from range B1
and to right of it on sheet Suppliers.


c) I am really confused with the last bit.

Which one?



sorry this is my first time using dynamic drop downs so I need a bit of
drop
down for dummies.

No problem there at all :))