Copy summary data to new sheet

D

Darrington SD

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.
 
J

Jim Cone

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" <[email protected]>
wrote in message
news:45423a4b-c418-4591-b8f1-087f2321450d@u28g2000prm.googlegroups.com...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you make a summary sheet? 0
how to copy and paste value from one sheet to another 4
Extracting data/using COUNTIFS 2
if > < on one tab - want total on a summary sheet 3
Adding data from multiple cell and linking to a new worksheet 3
Copy Data from 1 Sheet to Another 3
Totalling data from several workbooks to a Summary Sheet 1
copying data to summary sheet 2

Top