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
>