| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Running filters using a macro
I have 50 worksheets in a single workbook which all pull data from the same
source document. Being that I need to perform this function monthly, is there any way to automate the filtering process using a macro? |
|
#2
|
|||
|
|||
|
You could turn on the macro recorder as you perform the task manually.
Then, edit the resulting code, to make it generic, and run the code each month as required. If you need specific help with the code, you could provide more details about what you're trying to do. MarcusA wrote: I have 50 worksheets in a single workbook which all pull data from the same source document. Being that I need to perform this function monthly, is there any way to automate the filtering process using a macro? -- 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 | |||
| How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
| Running a Macro automatically from Excel | Excel Worksheet Functions | |||
| Prevent A Macro From Running If SpreadSheet is Filtered | Excel Worksheet Functions | |||
| How to stop getting the file save box when running a macro | Excel Discussion (Misc queries) | |||
| Shadows of the Pivottable Field List while macro is running | Excel Worksheet Functions | |||
Linear Mode
