| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To copy subtotal into another sheet
How I can copy Subtotal only into another sheet. Now Whenever I am copying
,entire data will go to next sheet. So please let me know to copy the subtotal data only to another sheet Thanks Pol |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To copy subtotal into another sheet
Hi Pol
F5Specialselect Visible cells onlyOK Then Copy and Paste -- Regards Roger Govier "pol" wrote in message ... How I can copy Subtotal only into another sheet. Now Whenever I am copying ,entire data will go to next sheet. So please let me know to copy the subtotal data only to another sheet Thanks Pol |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To copy subtotal into another sheet
Hi,
Hide the detail rows Select the range you want to copy EditGoto Click the [Special Cells] button Select: Visible Cells Go to where you want to copy the information EditCopy If this was helpful please say yes, thank you "pol" wrote: How I can copy Subtotal only into another sheet. Now Whenever I am copying ,entire data will go to next sheet. So please let me know to copy the subtotal data only to another sheet Thanks Pol |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
To copy subtotal into another sheet
if you want the subtotal to update on the 2nd sheet if you modify the data
on the original sheet -- you should just put a link in the cell of the 2nd sheet to the subtotal cell in your first sheet. does that make sense to you? -- Kathryn Groves "pol" wrote in message ... How I can copy Subtotal only into another sheet. Now Whenever I am copying ,entire data will go to next sheet. So please let me know to copy the subtotal data only to another sheet Thanks Pol |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy just the collapsed subtotal lines? | Excel Discussion (Misc queries) | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| copy the result of a subtotal | New Users to Excel | |||
| Excel - copy subtotal rows only | Excel Discussion (Misc queries) | |||
| copy subtotal information to new sheet | Excel Worksheet Functions | |||
Linear Mode
