create sheet from autofilter results

[umba-sr]

I need to know if there is a way to create a new sheet from the results of
another sheet which I just autofiltered.

I will give you an example.

I have a table with a first row as my heading with columns like - ID No.,
Employee name, Address, City etc. If I autofilter, let's say, City column
asking only for Los Angeles, how can I create another sheet with only those
results and the above heading row, but with no autofilter on. I know I can
copy the records, but I need something that want require to adjust sizes of
cells to the original sheet.

Thanks

[Debra Dalgleish]

You can use an Advanced Filter to extract the data to a different sheet.
There are instructions here:

http://www.contextures.com/xladvfilter01.html

umba-sr wrote:
> I need to know if there is a way to create a new sheet from the results of
> another sheet which I just autofiltered.
>
> I will give you an example.
>
> I have a table with a first row as my heading with columns like - ID No.,
> Employee name, Address, City etc. If I autofilter, let's say, City column
> asking only for Los Angeles, how can I create another sheet with only those
> results and the above heading row, but with no autofilter on. I know I can
> copy the records, but I need something that want require to adjust sizes of
> cells to the original sheet.
>
> Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html