I have a sheet which needs to display data in a specific
manner.
I have data in the following format
Store Code : Store Name : Region
AA : Bromley : 3
AB : Croydon : 3
etc....................
DE : Newcastle : 12
DG : Morpeth : 12
etc ...................

There are a total of 33 stores split into different
regions. I have a full list off screen and want to
populate the print area with only those from the region
the spread sheet is using to compare data sets. On the
cover the user selects the store code and the rest of the
sheet is populated with data from stores in the same
region pages 3 - 27. What I wanted was on the second page
to dynamicly show only the stores in the region being
examined. I have named each region as named areas.
i.e 'region3' 'region12' etc and named the cell where I
want the region pasted to or whown as 'regionpaste' What
I need to do is monitor Cell A70 to decide what region to
include in the printable area.
This may sound confusing but ask away if you don't
understand or mail me direct and I will send a copy of the
sheet to explain what I mean.
Any help would be usefull.