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
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
