Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create sheet from autofilter results
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
create sheet from autofilter results
You can use an Advanced Filter to extract the data to a different sheet.
There are instructions he 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Applying autofilter to protected sheet | Excel Discussion (Misc queries) | |||
with Autofilter on, display count results in lower left corner wit | Excel Worksheet Functions | |||
Create a sheet name, won't let me, says already sheet named that | Excel Worksheet Functions | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
Using the results from two seperate cells to create cell reference | Excel Worksheet Functions |