| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data filter
I have a workbook that has 3 worksheets in it. sheet one has an inflation
index. Sheet 2 is data entry for quotes. Sheet 3 is a duplicate of sheet 2 with the quote price inflated if a cell on Sheet 2 indicates to do so. Sheet 2 and 3 can be autofiltered to view certain locations. If you are going to auto filter sheet 2 to enter quotes only for a certain location(s), then you will want to see only those same locations on sheet 3 inflated. Is there any way to program the autofilter arrows so that if you filter sheet 2, it performs the same filter on sheet 3 so that the user doesn't have to repeat the steps? Sheet 3 is all formulas, so there is no user intervention to sheet 3 at all other than the fact that they have to re-filter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter, Cell Reference formula and copy formula on filter data | Excel Programming | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Data - Filter - Auto Filter | Excel Discussion (Misc queries) | |||
| in data/filter/auto filter | Excel Worksheet Functions | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Threaded Mode
