software

Hi

I have a workbook with six sheets numbered 1 thru 6, each representing
one of 6 depots.

Each sheet has in column A the dates from 1/1 to 12/31 (excluding
weekends). Columns B amp; C have units manufactured and value of units
manufactured, whilst columns D amp; E have units sold and value of units
sold. Columns B thru E are read in by lookups from the depots daily
production and sales returns.

I need to extract an array which will allow me to chart whatever the
users select from a menu offering

Depot - from one of six option buttons
Sales Units - by check box
Sales Value - by check box
Production Units - by check box
Production Value - by check box
Month (from a drop-down menu)

I can work out how to do it all except bring through the month. i.e.
the user selects February or November.

Any ideas?

Thanks--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=517192Hi Rob

I think I would be inclined to copy all 6 sets of 260 rows to a fresh
sheet, adding an additional column and filling that with the Depot name
as I copied across each block.
Then create a Pivot Table on the complete set of data, and a pivot
Chart. You can select any criteria you want to create your chart.
For more help on Pivot Tables take a look at Debra Dalgleish's site, and
scroll down to the section on Pivot Tables
www.contextures.com/tiptech.html

--
Regards

Roger Govierquot;Brisbane Robquot;
gt; wrote in
message
news:Brisbane.Rob.23xiky_1141112706.8439@excelforu m-nospam.com...
gt;
gt; Hi
gt;
gt; I have a workbook with six sheets numbered 1 thru 6, each representing
gt; one of 6 depots.
gt;
gt; Each sheet has in column A the dates from 1/1 to 12/31 (excluding
gt; weekends). Columns B amp; C have units manufactured and value of units
gt; manufactured, whilst columns D amp; E have units sold and value of units
gt; sold. Columns B thru E are read in by lookups from the depots daily
gt; production and sales returns.
gt;
gt; I need to extract an array which will allow me to chart whatever the
gt; users select from a menu offering
gt;
gt; Depot - from one of six option buttons
gt; Sales Units - by check box
gt; Sales Value - by check box
gt; Production Units - by check box
gt; Production Value - by check box
gt; Month (from a drop-down menu)
gt;
gt; I can work out how to do it all except bring through the month. i.e.
gt; the user selects February or November.
gt;
gt; Any ideas?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; Brisbane Rob
gt; ------------------------------------------------------------------------
gt; Brisbane Rob's Profile:
gt; www.excelforum.com/member.php...oamp;userid=25096
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=517192
gt;

Thanks - I'll give it a try--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: www.excelforum.com/member.php...oamp;userid=25096
View this thread: www.excelforum.com/showthread...hreadid=517192