Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summary by date
I have large no. records generate by daily operation about 3000/month.
have to summarize by customer and partno. and also orginized i monthorder, could anyone have hints to help marco coding ?? 1. input data Customer, Partno. , Qty , unit price, Date a , CD, 5, 20, 10/Jan/03 a , DVD, 2, 30, 12/Feb/03 b , CD, 3, 25, 15/Feb/03 b , DVD, 1, 35, 16/Feb/03 a , CD, 2, 21, 17/Feb/03 2. Customer, partno. , Date , Price, Date, Price, Jan/03, Feb/03 a , CD, 5 , 20 , 2 , 21, a , DVD , 2, 30, 0 , 0, b , CD , 3 , 25 , 0, 0, b , DVD , 0 , 0 , 1, 35, Thanks and appreciate for any of suggestion. Simo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
summary by date
Try a PivotTable, they are excellent for summarizing data
"BULEMOON" wrote in message ... I have large no. records generate by daily operation about 3000/month. I have to summarize by customer and partno. and also orginized in monthorder, could anyone have hints to help marco coding ?? 1. input data Customer, Partno. , Qty , unit price, Date a , CD, 5, 20, 10/Jan/03 a , DVD, 2, 30, 12/Feb/03 b , CD, 3, 25, 15/Feb/03 b , DVD, 1, 35, 16/Feb/03 a , CD, 2, 21, 17/Feb/03 2. Customer, partno. , Date , Price, Date, Price, Jan/03, Feb/03 a , CD, 5 , 20 , 2 , 21, a , DVD , 2, 30, 0 , 0, b , CD , 3 , 25 , 0, 0, b , DVD , 0 , 0 , 1, 35, Thanks and appreciate for any of suggestion. Simon --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
summary by date
Thanks Dale, since that will take sometime to invoke the setting
everytime to do this job. Do you have any idea to use Macro so that can simplify task. Thanks again. Dale Hymel wrote: *Try a PivotTable, they are excellent for summarizing data "BULEMOON" wrote in message ... I have large no. records generate by daily operation about 3000/month. I have to summarize by customer and partno. and also orginized in monthorder, could anyone have hints to help marco coding ?? 1. input data Customer, Partno. , Qty , unit price, Date a , CD, 5, 20, 10/Jan/03 a , DVD, 2, 30, 12/Feb/03 b , CD, 3, 25, 15/Feb/03 b , DVD, 1, 35, 16/Feb/03 a , CD, 2, 21, 17/Feb/03 2. Customer, partno. , Date , Price, Date, Price, Jan/03, Feb/03 a , CD, 5 , 20 , 2 , 21, a , DVD , 2, 30, 0 , 0, b , CD , 3 , 25 , 0, 0, b , DVD , 0 , 0 , 1, 35, Thanks and appreciate for any of suggestion. Simon --- Message posted from http://www.ExcelForum.com/ * --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
summary by date
since that will take sometime to invoke the setting
Not at all. Simply set up the Pivot reports as you want them to appear, and then use a dynamic range to determine the data each time, eg:- http://www.contextures.com/xlPivot01.html Now every time you delete your old data and paste in your new data, simply refresh the pivot reports you already have set up. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- Seasons Greetings and Very Best wishes to all :-) ---------------------------------------------------------------------------- "BULEMOON" wrote in message ... Thanks Dale, since that will take sometime to invoke the setting everytime to do this job. Do you have any idea to use Macro so that can simplify task. Thanks again. Dale Hymel wrote: *Try a PivotTable, they are excellent for summarizing data "BULEMOON" wrote in message ... I have large no. records generate by daily operation about 3000/month. I have to summarize by customer and partno. and also orginized in monthorder, could anyone have hints to help marco coding ?? 1. input data Customer, Partno. , Qty , unit price, Date a , CD, 5, 20, 10/Jan/03 a , DVD, 2, 30, 12/Feb/03 b , CD, 3, 25, 15/Feb/03 b , DVD, 1, 35, 16/Feb/03 a , CD, 2, 21, 17/Feb/03 2. Customer, partno. , Date , Price, Date, Price, Jan/03, Feb/03 a , CD, 5 , 20 , 2 , 21, a , DVD , 2, 30, 0 , 0, b , CD , 3 , 25 , 0, 0, b , DVD , 0 , 0 , 1, 35, Thanks and appreciate for any of suggestion. Simon --- Message posted from http://www.ExcelForum.com/ * --- Message posted from http://www.ExcelForum.com/ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.555 / Virus Database: 347 - Release Date: 23/12/2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal by Date and Summary in Lists? | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Summary of values from a date range | Excel Worksheet Functions | |||
Summary Help | Excel Programming |