Filtering and copying data to multiple tabs in Excel

Help
1

Hi,

I have a workflow that is opening an Excel spreadsheet and pasting a large amount of data into it. I would like to filter based on one of the columns and copy different filtered data to 3 separate tabs in Excel.

What would be the best method to do this please?

Thanks

2

@TRX You can First read the file after pasting using Read Range Activity which outputs a Datatable, and then you can use the Filter Datatable Activity on that Output Datatable to filter based on your Criteria and then Write the Data to the Sheets needed.