| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filtering data
Hi,
I need to filter some info from a list, then copy this info to another area of my speadsheet, i can do this by recording a macro and appying filters, but is ther an easier way regards johny 5 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
filtering data
If you're copying data to a different area, it may be more efficient to
use an Advanced Filter. You can record the steps as you do it manually. There are instructions in Excel's Help, and he http://www.contextures.com/xladvfilter01.html wrote: I need to filter some info from a list, then copy this info to another area of my speadsheet, i can do this by recording a macro and appying filters, but is ther an easier way -- 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 | |||
| Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
| Filtering Data | Excel Discussion (Misc queries) | |||
| Filtering data | New Users to Excel | |||
| Filtering Data | Excel Programming | |||
| Help with Filtering data and matching two data sets? | Excel Programming | |||
Hybrid Mode
