Thanks for the help with my DVD collection, I want to do something similar
with work but i'm not sure if its possible.

In Cells D5 and D7 I have 2 lists (Product and Area), when I select one of
each I need them to work like coordinates for a master table (products across
the top and areas down the side). Is there anyway to do this (I have about
104 products and around 2000 areas to put into this table).

Please help again, many thanks