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
 
You must log in or register to reply here.

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

Excel Help to copy information from one row at a time to another sheet 1
Quick/efficient way to VBA subtotal 2
How can I get Excel 2007 to consider only filtered cells? 2
Visible row index after applying a filter in Excel 1
Figuring out a lengthy formula. Probably quite simple... 3
Fill down visible cells only 4
Searching "Up" an Array 3
Need to combine two working formulas - not working. 2

Back
Top