Automatically update filtered list across worksheets

[Larzand]

How can I have the results of a filtered list automatically update when a change is made to the source list which is on another worksheet

I have one worksheet which is a list of events sorted by date. On another worksheet I want to show all the events that occur in a particular month. I can filter the list from the one sheet to another without a problem, but any changes made to the first sheet do not automatically appear on the second. If I add a new event to the main sheet, I would like it to automatically appear on the second (if it fullfills the criteria). How can this be done

 

[Don Guillett]

You could use a worksheet_change event on the sheet module by firing the
macro when the desired column changes to the desired condition (s)

--
Don Guillett
SalesAid Software
[email protected]

How can I have the results of a filtered list automatically update when a

change is made to the source list which is on another worksheet?

I have one worksheet which is a list of events sorted by date. On another

worksheet I want to show all the events that occur in a particular month. I
can filter the list from the one sheet to another without a problem, but any
changes made to the first sheet do not automatically appear on the second.
If I add a new event to the main sheet, I would like it to automatically
appear on the second (if it fullfills the criteria). How can this be done?