I have Table1 with data in Sheet1. So I have filter criteria base on the Table1 . So if I filter the Table1 in Sheet1 i would like to copy all those filtered in Table1 and put it in Table2 last row in Sheet2. that's all i need how to make it in VBA
Table1 columns,
Names, Location, City and Destination