Filter excel file multiple times, using FOR EACH ROW, saving each file

Help StudioX
,
1

Hello,

I have a need to take a large file and filter it multiple times, saving each filtered list as a separate file (in a directory folder). I am able to use the project workbook to apply the filters, but I am having a hard time trying to save each filtered file. Ultimately, I would need to make each file a pivot table, but I think I can handle that step.

image
image620×679 47.6 KB

2

@Stewart_Jermaine

Read the data using read range…then use filter datatable and then paste the data using write range activity to a new sheet and the sheetname can be the filter value you use…so that each set is psted separately

Hope this helps

Cheers

3

@Anil_G

Thanks so much for the prompt response. I will try this out and report back!

JS

1 Like
4

@Anil_G

I actually need to save each filtered list as a separate file and each of these would go to different folders, based on the business unit. Would I still go about it the same way?

5

@Stewart_Jermaine

Yes your approach would still be same…but instead of different sheetnames you can use multiple file locations or filenames and then move them
As you need

Cheers