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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand and collapse rows 7
insert rows with formulas 1
Grouping - limit to number of nested groups? 2
adding rows into the table 1
Count Number of Visible Rows in Filtered View 2
Combine Lists 1
Quick/efficient way to VBA subtotal 2
Linking spreadsheet where rows are not aligned, but are when portions are hidden 3

Top