Selecting Dynamic Data Range

M

matt4003

Hello Everyone,

I have been searching for awhile now to find an answer..but with n
luck.

My question:
I have 2 years of data broken down by month (columns) and manufacturin
facility (2-9 rows)..each cell represents a revenue. My boss has aske
me to give him the ability to set the start month and end month an
only that data is shown....

Here is how it is laid out:

Jan 04|Feb04|Mar04|Apr04|etc...
Fab1
Fab2
Fab3
Fab4
Fab5
Fab6
Fab7

I use a pivot table to get this format, since the initial data is muc
more complicated...any ideas how I could provide something so if m
boss only wants to see Feb04 through Apr04, he can??

Your help is appreciated!!

Cheers,
Mat
 
N

Nick Hodge

Matt

If this is in a pivot table he can go to the months header and select only
the months he wants. If by chance these are also quarters that are being
looked at then he could right-click on the same header and select 'Group'
and change the displayed grouping to 'Quarters'.

As these are months, there can only be twelve although if you are showing
years there could be many more. If this is the case XL XP and 2003 added a
'Select all' feature in the pivot table header drop-down. This would mean
he could click it to select all, click again to deselect all and then select
the three, etc he wanted.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top