Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i copy subtotals without the underlying data?
Hi
I want to copy the subtotals only from one sheet to another, there must be a way?? Thanks Homer "D'oh" |
#2
|
|||
|
|||
Hi Homer
display only the subtotals on the screen and click on one of them choose edit / goto, click the Special button select visible cells only click OK now COPY and PASTE as usual. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Homer" wrote in message ... Hi I want to copy the subtotals only from one sheet to another, there must be a way?? Thanks Homer "D'oh" |
#3
|
|||
|
|||
Hi
Reduce the grouping to show just the information you want. Hit F5 and select Visible Cells. Ctrl+C to copy. Move to where you want the totals and click Edit / Paste Special / Values. -- Andy. "Homer" wrote in message ... Hi I want to copy the subtotals only from one sheet to another, there must be a way?? Thanks Homer "D'oh" |
#4
|
|||
|
|||
If you do this often, you may wish to place the icon on your toolbar.
Right click in the toolbar and choose "Customize", then <Commands tab, Click <Edit in the left window, and scroll down to the next to last item in the right window. Click and drag it to your toolbar. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Homer" wrote in message ... Hi I want to copy the subtotals only from one sheet to another, there must be a way?? Thanks Homer "D'oh" |
#5
|
|||
|
|||
Thanks JulieD and AndyB thats done it!
"JulieD" wrote: Hi Homer display only the subtotals on the screen and click on one of them choose edit / goto, click the Special button select visible cells only click OK now COPY and PASTE as usual. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Homer" wrote in message ... Hi I want to copy the subtotals only from one sheet to another, there must be a way?? Thanks Homer "D'oh" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy the underlying e-mail hyperlink information from a . | Excel Discussion (Misc queries) | |||
Copy Function | Excel Discussion (Misc queries) | |||
When using subtotals, how do I copy and paste only the subtotals . | Excel Worksheet Functions | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
How do I copy subtotals to another sheet? | Excel Worksheet Functions |