Hi sir as the title say, i want to filter a table depending on the value form different sheet
i have 2 sheets
Sheet 1 is where the cell is located with a date (Example cell is B1)
on
Sheet 2 i have a table with a column "DATE", i want to filter the column DATE, depending on the given date on sheet 1 B1
im using this code but i think its not working
thanks in advance![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
i have 2 sheets
Sheet 1 is where the cell is located with a date (Example cell is B1)
on
Sheet 2 i have a table with a column "DATE", i want to filter the column DATE, depending on the given date on sheet 1 B1
im using this code but i think its not working
ActiveSheet.ListObjects("Table8").Range.AutoFilter Field:=1, Criteria1:= range. B1
thanks in advance
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)