Hi Mickey

As Pete has already suggested, Pivot Tables are probably the best way to go.

For help on Pivot Tables take a look at the following sites

Mike Alexander has some great video tutorials which will show you what they
are about
http://www.datapigtechnologies.com/ExcelMain.htm

Debra Dalgleish has lots of help in dealing with all of the issues within
Pivot Tables
http://www.contextures.com/tiptech.html
scroll down to the section on Pivot Tables

Ed Fereiro has a great tutorial at
http://www.edferrero.com/ExcelTutori...9/Default.aspx

These should be enough to get you started.
--
Regards
Roger Govier



"Mickey" wrote in message
...
Hi Pete,
Many thanks for the response. Sorry for not explaining it clearer. What I
was looking for was the best way to have the 25 areas in a column and then
further columns of -

Area || 'This Year || Last Year || Change || % Change.
---------------------------------------------------------------
North
South
West
East

Then I wanted to enable the user to choose one of the 15 categories from a
list so that the table of 25 areas then displayed the performance results
for the selected category. This way I could then avoid having a seperate
worksheet for eac h area and/or category being measured.

Best Wishes,
Mickey