Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste only subtotals, not individual date that makes up subtotal
i only want to copy & paste the subtotals, not the supporting data
thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste only subtotals, not individual date that makes up subtotal
Hi Judy,
select the subtotals copy and paste special as values "judybart" escreveu: i only want to copy & paste the subtotals, not the supporting data thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste only subtotals, not individual date that makes up subtot
where is the subtotal copy?- if i use the regular copy & paste special
-values i still paste all the supporting date not just the subtotal rows "Marcelo" wrote: Hi Judy, select the subtotals copy and paste special as values "judybart" escreveu: i only want to copy & paste the subtotals, not the supporting data thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste only subtotals, not individual date that makes up subtot
Try hiding the details
then select the range and then one more step edit|goto|special|visible cells only Now do the edit|copy and edit|paste. judybart wrote: where is the subtotal copy?- if i use the regular copy & paste special -values i still paste all the supporting date not just the subtotal rows "Marcelo" wrote: Hi Judy, select the subtotals copy and paste special as values "judybart" escreveu: i only want to copy & paste the subtotals, not the supporting data thanks -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
paste only subtotals, not individual date that makes up subtot
Ok Judy, you are coping the entire figures, as the rows are hiding,
try to select the area, press F5 click on the Special botton, select visible only. hope this helps regards from Brazil Marcelo "judybart" escreveu: where is the subtotal copy?- if i use the regular copy & paste special -values i still paste all the supporting date not just the subtotal rows "Marcelo" wrote: Hi Judy, select the subtotals copy and paste special as values "judybart" escreveu: i only want to copy & paste the subtotals, not the supporting data thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count between start date and end date | Excel Discussion (Misc queries) | |||
Subtotals including blank rows | Excel Discussion (Misc queries) | |||
average value from a table | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) |