| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying from Subtotal Data
I have a table in which I have inserted subtotals. I would like to copy
certain cells from the table to another area of the spreadsheet. When only the subtotals are showing and the other rows are hidden I would like to be able to copy only the subtotal rows. Is there a way to ignore the hidden rows and copy only the subtotal rows to the clipboard? For example, I have data in rows 1 - 50. In rows 10, 20, 35 and 50 are subtotals. When I collapse the table only those rows with subtotals are showing but if I select those subtotal rows to be copied all of the rows btw. them are also sent to the clipboard. Can I get only rows 10, 20, 35, and 50 to copy? Thanks for your assistance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying from Subtotal Data
Hide the details in the range that has subtotals
select the range to copy edit|goto|special|visible cells only Now do your copy and paste SJT wrote: I have a table in which I have inserted subtotals. I would like to copy certain cells from the table to another area of the spreadsheet. When only the subtotals are showing and the other rows are hidden I would like to be able to copy only the subtotal rows. Is there a way to ignore the hidden rows and copy only the subtotal rows to the clipboard? For example, I have data in rows 1 - 50. In rows 10, 20, 35 and 50 are subtotals. When I collapse the table only those rows with subtotals are showing but if I select those subtotal rows to be copied all of the rows btw. them are also sent to the clipboard. Can I get only rows 10, 20, 35, and 50 to copy? Thanks for your assistance. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying from Subtotal Data
Thank you very much.
"Dave Peterson" wrote: Hide the details in the range that has subtotals select the range to copy edit|goto|special|visible cells only Now do your copy and paste SJT wrote: I have a table in which I have inserted subtotals. I would like to copy certain cells from the table to another area of the spreadsheet. When only the subtotals are showing and the other rows are hidden I would like to be able to copy only the subtotal rows. Is there a way to ignore the hidden rows and copy only the subtotal rows to the clipboard? For example, I have data in rows 1 - 50. In rows 10, 20, 35 and 50 are subtotals. When I collapse the table only those rows with subtotals are showing but if I select those subtotal rows to be copied all of the rows btw. them are also sent to the clipboard. Can I get only rows 10, 20, 35, and 50 to copy? Thanks for your assistance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
| How to auto-increment data source cell references when copying cha | Charts and Charting in Excel | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Copying data within worksheets with lookups | Excel Discussion (Misc queries) | |||
| Using more than one subtotal with same data set | Excel Worksheet Functions | |||
Linear Mode
