Copy only visible rows

N

noyb

I have a sheet with 4 levels of subtotals and I want to copy only rows
visible at level 2. Don't need the formulas or hidden rows. Is this
possible? Thanks
 
D

Dave Peterson

Hide the details you don't want.
Select the visible cells
Edit|goto special|check Visible cells only
rightclick|copy

and edit|paste at your new location.
 
K

Keith Streich

Perhaps pasting a picture link would be better and easier, if it's just for
printing or to view the information. The link could also be dynamic,
updating when ever the original data changes.

Keith
 
Top