Jim frfom Calgary
New Member
- Joined
- Mar 5, 2004
- Messages
- 5
I find the autofilter needs to be run everytime there is a data change. Can it be setup so when I change my data the changed data appears in the autofilter range without having to run the autofilter again?
My scenario: I have a parts list that gets copied to an order form. The order form auto filters any parts that aren't selected. If I select a new part or delete an existing part from the parts list the order form now needs the auto filter ran again. Is there a way to have the filter automatically update including the changed data?
My scenario: I have a parts list that gets copied to an order form. The order form auto filters any parts that aren't selected. If I select a new part or delete an existing part from the parts list the order form now needs the auto filter ran again. Is there a way to have the filter automatically update including the changed data?