Hi I have a worksheet of raw data and I want to apply a filter and have the filtered data copied to a new worksheet. I want it such that whenever the raw data in the first sheet is replaced, the second worksheet is automatically updated with the filtered data. Please help, deadline coming up soon!

Thanks