How do I save a filtered subset of a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to hide columns and filter my worksheet, then save only the visible
cells. Is there a way to save a subset of a worksheet in this way
 
Create a new workbook.
Back to the original worksheet
Select all the cells (ctrl-a, twice in xl2003)
Edit|Goto special|Visible
Edit|Copy

back to the worksheet in the new workbook.
Edit|paste special|Values
edit|paste special|Formats

Save the new workbook.

If you need a macro, you can record one when you do it once manually.
 
Thanks, that did the trick
Julia

Dave Peterson said:
Create a new workbook.
Back to the original worksheet
Select all the cells (ctrl-a, twice in xl2003)
Edit|Goto special|Visible
Edit|Copy

back to the worksheet in the new workbook.
Edit|paste special|Values
edit|paste special|Formats

Save the new workbook.

If you need a macro, you can record one when you do it once manually.
Click to expand...
 
Back
Top