Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection by month
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 & C have units manufactured and value of units manufactured, whilst columns D & 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: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=517192 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection by month
Hi 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 http://www.contextures.com/tiptech.html -- Regards Roger Govier "Brisbane Rob" wrote in message news:Brisbane.Rob.23xiky_1141112706.8439@excelforu m-nospam.com... 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 & C have units manufactured and value of units manufactured, whilst columns D & 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: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=517192 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selection by month
Thanks - I'll give it a try -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=517192 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
Add one month to the previuos month | Excel Discussion (Misc queries) | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions |