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.
How do I overcome this problem?