copy just subtotals ?
Im having a document with 5 levels of subtotals.. I want to mark an area containing just subtotals, and copy and past these as values to a seperate sheet. However when trying to do so, I get all the data under the subtotals too... is there a way around this? -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=501982 |
copy just subtotals ?
Hi, I'm not sure if I understand your layout correctly but try selecting your range of subtotals & then pressing [alt+'] to limit the selection to visible cells. Or edit - go to - special - visible cells only. Then try the copy & paste special as values. Does this help? Another option may be to use John Walkenbach's "copy multiple selection" http://j-walk.com/ss/excel/files/copymult.exe sourced from http://j-walk.com/ss/excel/files/developer.htm Hth, Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=501982 |
copy just subtotals ?
Didn't know that... Edit - Goto - Special - Visable cells only... a great function.. thanks -- Ctech ------------------------------------------------------------------------ Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745 View this thread: http://www.excelforum.com/showthread...hreadid=501982 |
copy just subtotals ?
Yes it is great - I'm pleased I could help. Sorry about the typo in my last post, the correct shortcut for selecting visible cells only is [alt+;] not [alt+'] as I posted previously. btw, the shortcut to bring up the "Go to" window is [F5]. Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=501982 |
All times are GMT +1. The time now is 04:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com