How do I copy/paste subtotaled data without also copying the detail (hidden rows)?
B bfordmelson Dec 13, 2005 #1 How do I copy/paste subtotaled data without also copying the detail (hidden rows)?
P Peo Sjoblom Dec 13, 2005 #2 Select the range, press F5, click special and select visible cells only, click OK, copy and paste
R Ron Coderre Dec 13, 2005 #3 Try this: Hide the detail rows Select the range you want to copy Edit>Goto> Click the [Special Cells] button Select: Visible Cells Edit>Copy Go to the destination range Edit>Paste Special>Values Is that what you're looking to do? *********** Regards, Ron
Try this: Hide the detail rows Select the range you want to copy Edit>Goto> Click the [Special Cells] button Select: Visible Cells Edit>Copy Go to the destination range Edit>Paste Special>Values Is that what you're looking to do? *********** Regards, Ron
