software

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

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

www.contextures.com/xladvfilter01.html

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