MattExcel April 20, 2017 at 15:34:00 Specs: Windows 7
say have a list of tasks and i have a filter applied to show only "In Progress". When i change that task to "On hold" or "Completed" i would like them to disappear from the list. how can i get the filter to do this automatically without me having to click refresh?
Sure, just put it in both worksheets. However, you can only have one Worksheet_Change in any given sheet, so if you are talking about the same sheets as in your other thread, you may run into problems when you add the Filter code to the "move row" code. The only way to know is to play around.
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Compnet Ventures, LLC hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.