Running filters using a macro

G

Guest

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?
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet With Multiple Data Sources 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro to copy value in field and insert it into filter 2
Filters and subtotals 2
Using a macro to paste into first empty row in a new worksheet 3
finding duplicate addresses across 2 worksheets in the same workbo 2
Conditional SUMPRODUCT or SUMPRODUCT with Filters 4
Automate Combine 2 Spreadsheets into two worksheets 5

Top