I am trying to make a worksheet that will allow my coworkers to make quotes.
I have a workbook that has items and pricing on one worksheet and the
corresponding items on a quote worksheet. I have an autofilter put on the
quote sheet that allows for the quote to be adjusted to the right items. e.g.
if I select an item on the pricing sheet, I can use autofilter on the quote
sheet to show only that item. My question is how to make the autofilter
update on its own. I don't want to have my coworkers have to type in the
custom (is greater then or equal to) field. Is there a way that I can setup
the worksheet so that anytime it is open it will use my custom filter
automatically?