Use Read Range activity without giving any particular range of the excel sheet. All the data from the workbook will be extracted into a data table. Then you can add filters (if any) to that data table and copy the values into the other workbook.
3 Likes