| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic update of filter
I would need to have an automatic update of filter, is it possible?
The situation is the following: I have a questionnaire with 250 questions, depending on the user some questions are not applicable. I have a filtro in order to show only applicable questions, but when I change the user the filter does not automatically update itself. Is it possible? This is urgent... Thank you! claudia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update of filter
Hi,
In 2007 you can choose Data, Reapply. In 2003 you will need to use VBA. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "claudia" wrote: I would need to have an automatic update of filter, is it possible? The situation is the following: I have a questionnaire with 250 questions, depending on the user some questions are not applicable. I have a filtro in order to show only applicable questions, but when I change the user the filter does not automatically update itself. Is it possible? This is urgent... Thank you! claudia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Advanced Filter - Automatic Update | Excel Worksheet Functions | |||
| chart automatic update | Excel Worksheet Functions | |||
| Automatic Update | Charts and Charting in Excel | |||
| Automatic update | Excel Discussion (Misc queries) | |||
Linear Mode
