Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |