| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy summary data to new sheet
I have a list of about 600 account codes of varying lengths and
segments with dollar values attached. I have sorted by the account and put a subtotal on each varying account code. The data is now shown at the summary level which dropped the number of rows I see to about 60. I am trying to copy just the summary data into another sheet in order to standardize the account codes easily but do not know how not to get all the detail lines attached. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy summary data to new sheet
Copy just the visible cells and paste on the other sheet...
Select the 60 rows Edit (menu) | Go To | Special (button) | Visible Cells Only -- Jim Cone Portland, Oregon USA . http://www.mediafire.com/PrimitiveSoftware . (free and commercial excel programs) "Darrington SD" wrote in message ... I have a list of about 600 account codes of varying lengths and segments with dollar values attached. I have sorted by the account and put a subtotal on each varying account code. The data is now shown at the summary level which dropped the number of rows I see to about 60. I am trying to copy just the summary data into another sheet in order to standardize the account codes easily but do not know how not to get all the detail lines attached. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate Data from Summary Sheet | Excel Discussion (Misc queries) | |||
| copying data to summary sheet | Excel Worksheet Functions | |||
| Referencing cells and copy rows of data back to summary sheet | Excel Discussion (Misc queries) | |||
| How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
| Multiple sheet data summary | Excel Worksheet Functions | |||
Linear Mode
