I have a list which I have subtotaled. I now want to work exclusively with the subtotal lines. How do I delete the data and keep just the subtotal lines? I've tried copy, paste special values, sort and copy over the subotals, but there must be an easier way...AND I have another important issue that presents a challenge...
In each of the lines there is data I want included in the new subtoal lines.
I am subtotalling by an id number for each line. All of the items for each id number (ROW) will be the same except the dollar amounts. Like this...
Smith ID2334 100 200 Act Blue
Smith ID2334 300 600 Act Blue
Jones ID1254 222 333 DED Green
Jones ID1254 444 666 DED Green
Now when I subtotal by ID # I get this:
Smith ID2334 100 200 Act Blue
Smith ID2334 300 600 Act Blue
ID2334TOTAL 400 800 (BOLD)
Jones ID1254 222 333 DED Green
Jones ID1254 444 666 DED Green
ID2334TOTAL 666 999 (BOLD)
But what I want is:
Smith ID2334 100 200 Act Blue
Smith ID2334 300 600 Act Blue
Smith ID2334TOTAL 400 800 Act Blue
Jones ID1254 222 333 DED Green
Jones ID1254 444 666 DED Green
Jones ID1254TOTAL 666 999 Act Blue
Then I just want those total lines left so I can do additional calculations with those line items.
So I'm just left with a list of the subtotals that included the other data elements
Like this:
Smith ID2334TOTAL 400 800 Act Blue
Jones ID1254TOTAL 666 999 Act Blue
Excecpt for the fact it doesn't keep the other data elements, this is what the outline view looks like, but I don't know how to keep just that.
I usually go in and copy down the data into the subtotal line..but I have 47,000 lines and not 20 hours to do this.
Is this possible?
Thanks!!!!
In each of the lines there is data I want included in the new subtoal lines.
I am subtotalling by an id number for each line. All of the items for each id number (ROW) will be the same except the dollar amounts. Like this...
Smith ID2334 100 200 Act Blue
Smith ID2334 300 600 Act Blue
Jones ID1254 222 333 DED Green
Jones ID1254 444 666 DED Green
Now when I subtotal by ID # I get this:
Smith ID2334 100 200 Act Blue
Smith ID2334 300 600 Act Blue
ID2334TOTAL 400 800 (BOLD)
Jones ID1254 222 333 DED Green
Jones ID1254 444 666 DED Green
ID2334TOTAL 666 999 (BOLD)
But what I want is:
Smith ID2334 100 200 Act Blue
Smith ID2334 300 600 Act Blue
Smith ID2334TOTAL 400 800 Act Blue
Jones ID1254 222 333 DED Green
Jones ID1254 444 666 DED Green
Jones ID1254TOTAL 666 999 Act Blue
Then I just want those total lines left so I can do additional calculations with those line items.
So I'm just left with a list of the subtotals that included the other data elements
Like this:
Smith ID2334TOTAL 400 800 Act Blue
Jones ID1254TOTAL 666 999 Act Blue
Excecpt for the fact it doesn't keep the other data elements, this is what the outline view looks like, but I don't know how to keep just that.
I usually go in and copy down the data into the subtotal line..but I have 47,000 lines and not 20 hours to do this.
Is this possible?
Thanks!!!!