MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pasting cells which are from subtotal?


Posted by Rick M on February 07, 2001 1:21 PM

How can I paste the cells copied from a sheet which have been colapsed to show the subtotals only?
Thanks?????


Posted by Dave Hawley on February 07, 2001 9:00 PM

Hi Rick

I take it you mean you only want the Visible cells ? if so simply select any cell within you table and push F5 then click Special|Visible cells, click OK. Now copy and paste onto another sheet.

DaveOzGrid Business Applications