hello all

i have the following macro that "auto filters" based on the selection in column K (which are dates).

now the issue is, if i select a date, the macro upon "event change" will automatically filter the data in the respective table below row 70 on the sheet. but if i change the date in column K, it will not "clear the data" in row 70 etc so the original data is kept in row 70 and also the new date data - which is incorrect.

can someone pls help me with the logic here.



Please Login or Register  to view this content.
thanking you in advance.