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
|
|||
|
|||
Subtotals - Copy the Subtotals into a new sheet
Hi,
Using subtotals to summarise, say, a 1000 rows of data into 50 rows of subtotals. I want to take those 50 rows into another sheet and then work on just those 50 rows to produce a report. I don't want the underlying detail to appear in the new sheet. It sounds a bit like pivot tables but I don't want to go there! Any ideas please. Thanks for looking. Paul |
#2
|
|||
|
|||
Subtotals - Copy the Subtotals into a new sheet
Hi
The way I do it is to show just the subtotals themselves, then Edit / Go to / Visible. Copy these and then Paste Special / Values onto the other sheet. -- Andy. wrote in message ... Hi, Using subtotals to summarise, say, a 1000 rows of data into 50 rows of subtotals. I want to take those 50 rows into another sheet and then work on just those 50 rows to produce a report. I don't want the underlying detail to appear in the new sheet. It sounds a bit like pivot tables but I don't want to go there! Any ideas please. Thanks for looking. Paul |
Thread Tools | |
Display Modes | |
|
|