If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copy detail to summary row in outline
I was given a file in outline form. It has summary rows which include the
quantity. How can I copy detail information to that summary row? Example: Let's say one of the groups is all a type of chair, and the detail rows are same type of chair different color. So the quantity of each color would be different, but the price is the same. The summary row has the total quantity for that type of chair, but not the price. How can I put the price in the summary row, so I can calculate total ? Item, Quantity, Price blue, 3, $50 red, 10, $50 green, 2, $50 Summary Chair, 15 Is there a function where I can have Excel put the $50 in the Summary row automatically? |
#2
|
|||
|
|||
copy detail to summary row in outline
Try clearing the outline and using Data--Subtotals.
http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "Hobbes2006" wrote in message ... I was given a file in outline form. It has summary rows which include the quantity. How can I copy detail information to that summary row? Example: Let's say one of the groups is all a type of chair, and the detail rows are same type of chair different color. So the quantity of each color would be different, but the price is the same. The summary row has the total quantity for that type of chair, but not the price. How can I put the price in the summary row, so I can calculate total ? Item, Quantity, Price blue, 3, $50 red, 10, $50 green, 2, $50 Summary Chair, 15 Is there a function where I can have Excel put the $50 in the Summary row automatically? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why are outline numbered list limited to 9 levels? | J. Knoernschild | General Discussion | 9 | November 9th, 2006 11:41 AM |
DSum in update query | Esrei | General Discussion | 7 | June 13th, 2005 07:27 PM |
Access Mail Merge to Word.doc files ? | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 18th, 2005 06:31 PM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Summary Functions taking too long and Dynamic Chang of Detail Field Backgrounds | Derrick | Setting Up & Running Reports | 2 | July 2nd, 2004 01:42 PM |