Hello all

I need some advice for a template I'm creating. It is very complex and I
need to make it as easy as possible for the users. It will be used to track
product report that are sent from central site to country affiliates, when
they receive the report they have to return a tracking sheet stating when and
whether they submitted the report to their local authority. We do this
tracking summary once a month. So one month's summary will cover x number of
products and each product will cover x number of countries.

The current design is that each worksheet contains data for one specific
product report, and the rows of the worksheet are the list of countries that
the report was sent to. These all map to a summary worksheet which calculates
the statistics.

Each month will be different and so what worries me is how to keep all the
formulas and summary statistics whilst being able to varry the number of
products/countries.

My ownly real workable idea is that all the possible countries will be
entered on each worksheet and there will be a large number of worksheets so
the user will have to delete what they don't need. But that is not only
confusing, but also time consuming. So I would really appreciate other ideas!

Thank you in advance
Joanne