This filter is for static report, every time one has to exclude item in sheet 2 which are coming in sheet 1. I want to make it dynamic. If some item comes in sheet 1, it should be automatically removed from sheet 2. Any idea in this?
If possible, could you share a packaged workbook or screenshots of what you have done so far?