I want to filter a table in my excel workbook, and copy the filtered data and paste it in another workbook.
So, I would run a macro that filters the data, and read range occurs. After read range, the other workbook would open and the data from read range would be pasted. However, when i run it, there are no errors but all the data is copied over to the other workbook, but when i opened the data workbook, it shows the workbook data is filtered.
Thank you for your replies! I realised that i can use that function and there is no issues with it. Thank you for your inputs!
However, is it possible for me filter options to filter data rows based on the column containing a specific string? Like filter the results that have  in the column (eg.  James) would be filtered?