Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
group summary totals
Hello:
A few days ago, a very nice person out here on the message board showed me how a macro could be developed in Excel to automatically total a column in Excel without the end user's having to click the @SUM button. This was great, considering that this Excel data had been imported from another application and the totaling of the column therefore had to be automatic upon the dumping of data to Excel. Now, in the same vein, I need to find a way to have Excel automatically total the grouping of data within the spreadsheet. This grouping is similar to the grouping that could be conducted through Crystal Reports or through SQL Reporting Services. The group would be based on the vendor IDs appearing in a column of the srpeadsheet. In other words, the amounts in the spreadsheet would be grouped and subtotaled by the vendor ID column. Is it possible to develop a macro that would automatically do this after the data is dumped to Excel? And, if so, how? Thanks! childofthe1980s |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
group summary totals
Dump the Data
Turn on the macro Recorder (tools=Macro=Record a New Macro) Select the upper left corner of you data then do Data=SubTotal Walk through the wizard. when the Subtotals have been applied, then turn off the macro recorder and look at the recorded code. You can then generalize it to suit your needs. -- Regards, Tom Ogilvy "childofthe1980s" wrote: Hello: A few days ago, a very nice person out here on the message board showed me how a macro could be developed in Excel to automatically total a column in Excel without the end user's having to click the @SUM button. This was great, considering that this Excel data had been imported from another application and the totaling of the column therefore had to be automatic upon the dumping of data to Excel. Now, in the same vein, I need to find a way to have Excel automatically total the grouping of data within the spreadsheet. This grouping is similar to the grouping that could be conducted through Crystal Reports or through SQL Reporting Services. The group would be based on the vendor IDs appearing in a column of the srpeadsheet. In other words, the amounts in the spreadsheet would be grouped and subtotaled by the vendor ID column. Is it possible to develop a macro that would automatically do this after the data is dumped to Excel? And, if so, how? Thanks! childofthe1980s |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Summary Sheet Totals | 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 Sheet Totals | Excel Discussion (Misc queries) |