Basically like this (assuming Excel is installed):

1. Open the file.
2. Get multiple cells to read the cells to a table. (Make sure you have enough RAM to hold everything in memory.)
3. Close the file.
4. Open the new file.
5. Write the table to the new file.
6. Save/Close the file.

Any filtering can be done at the table level between steps 3 and 4. There are Data Table actions that will do some filtering, such as removing duplicate rows or sorting. Other types of filtering (value filtering for example) would have to be done in a loop using some counters.

That’s the fewest number of actions and the least amount of window switching (that takes time).