How do I save a filtered subset of a worksheet?
 

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.


quixoposto wrote:

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

--

Dave Peterson

Thanks, that did the trick
Julia

"Dave Peterson" wrote:

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.


quixoposto wrote:

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

--

Dave Peterson