Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help
6060 50
6060 800 6070 700 6070 60 6070 410 i need to insert rows to separate by account number and and add totals so that it should look like this 6060 50 6060 800 850 6070 700 6070 60 6070 410 1170 thans for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help
How about using something built-in that's very close.
Add headers to your data if you don't have them already. Then select the range ryou want to subtotal (A1:B999???) And sort by that first column Then Data|subtotal At each change in the first field, sum the second. You can hide the details using the outlining symbols at the left if you want. If you only want to get the subtotals, you could use data|pivottable. If you've never use pivottables, here are a few links: Debra Dalgleish's pictures at Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivottables.htm And Debra's own site: http://www.contextures.com/xlPivot01.html John Walkenbach also has some at: http://j-walk.com/ss/excel/files/general.htm (look for Tony Gwynn's Hit Database) Chip Pearson keeps Harald Staff's notes at: http://www.cpearson.com/excel/pivots.htm MS has some at (xl2000 and xl2002): http://office.microsoft.com/downloads/2000/XCrtPiv.aspx http://office.microsoft.com/assistan...lconPT101.aspx andresg1975 wrote: 6060 50 6060 800 6070 700 6070 60 6070 410 i need to insert rows to separate by account number and and add totals so that it should look like this 6060 50 6060 800 850 6070 700 6070 60 6070 410 1170 thans for your help -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro help
thanks a lot
"Dave Peterson" wrote: How about using something built-in that's very close. Add headers to your data if you don't have them already. Then select the range ryou want to subtotal (A1:B999???) And sort by that first column Then Data|subtotal At each change in the first field, sum the second. You can hide the details using the outlining symbols at the left if you want. If you only want to get the subtotals, you could use data|pivottable. If you've never use pivottables, here are a few links: Debra Dalgleish's pictures at Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivottables.htm And Debra's own site: http://www.contextures.com/xlPivot01.html John Walkenbach also has some at: http://j-walk.com/ss/excel/files/general.htm (look for Tony Gwynn's Hit Database) Chip Pearson keeps Harald Staff's notes at: http://www.cpearson.com/excel/pivots.htm MS has some at (xl2000 and xl2002): http://office.microsoft.com/downloads/2000/XCrtPiv.aspx http://office.microsoft.com/assistan...lconPT101.aspx andresg1975 wrote: 6060 50 6060 800 6070 700 6070 60 6070 410 i need to insert rows to separate by account number and and add totals so that it should look like this 6060 50 6060 800 850 6070 700 6070 60 6070 410 1170 thans for your help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |