How do I paste subtotals only of a list into another worksheet without the background data?
G Greg glenn Mar 7, 2005 #1 How do I paste subtotals only of a list into another worksheet without the background data?
P Peo Sjoblom Mar 7, 2005 #2 Adjust the subtotals to your liking, select the range, press F5 and select special and visible cells only copy and paste
Adjust the subtotals to your liking, select the range, press F5 and select special and visible cells only copy and paste
