The best way forward?
Hi,
Please could someone advise me on the best way forward to do this?
I have 25 'areas' and some 20 'categories'. I need to display these so that
each area can look at it's own performance or look at the categories across
each area. I was wondering if there is a recommended way to say create two
worksheets, one for areas and one for categories, then as an example allow a
user to select an area from a list and have the display then show the
required data.
For example, on the categories sheet, the initial display would be the sum
of all catrgories across all areas, then a user could select an individual
catrgory and see how each area has performed.
Would the best way forward be vlookups. index/match or database functions?.
Any advise would be greatly appreciated. Also any good links to study the
suggested methods?.
Thanks,
Mickey
|