|
| 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
December 15th, 2005, 05:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy subtotaled data without the underlying details?
I want to copy the subtotaled data to another part of the worksheet or a new
worksheet without the underlying details. If I click and drag the area I want to copy it picks up all the hidden rows. I don't want them. 
|
|
#2
December 15th, 2005, 06:25 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I copy subtotaled data without the underlying details?
Try this:
Hide the detail rows Select the range you want to copy EditGoto Click the [Special Cells] button Select: Visible Cells EditCopy Go to the destination range EditPaste SpecialValues Does that help? *********** Regards, Ron "DBergesen" wrote: I want to copy the subtotaled data to another part of the worksheet or a new worksheet without the underlying details. If I click and drag the area I want to copy it picks up all the hidden rows. I don't want them.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Microsoft Office should use an advance data crosslinking model | m_jurrens | General Discussions | 0 | December 15th, 2005 07:33 AM |
| Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
| Rapid input Via datasheet | RudyR_Seattle | General Discussion | 4 | January 31st, 2005 01:33 AM |
| Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |
Linear Mode
