Filtering

  • Thread starter Thread starter Margaret
  • Start date Start date
M

Margaret

I have a table that each month will be updated and
replaced. In this table, all twelve months of the year
will be included. I would like to be able to
automatically filter the table from month-to-month. The
filter would change, so that in the month of May, the
filter will be "05", and for the month of June it would
be "06".

Can I do this through a macro?
 
When you say "all twelve months of the year will be included" do you mean
that you have a separate column for each month of the year? If that's what
you mean, then you need to rethink your structure. That's the way a
spreadsheet would work but not the way a database works.
 
Back
Top