Copy only visible rows

  • Thread starter Thread starter noyb
  • Start date Start date
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
 
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.
 
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
 
Back
Top