one excel sheet into two different output files

Question

Hello Everyone,

Is it possible for me to have two different output files from one input data? I have an excel sheet that i need to sort by type and have separate sheets or files by it's type.

I need to separate all the "STO" in column E into a different sheet or file.

P1P2P3RESSOSTO_Status_7_7_2020_11_13.xlsx

grazitti_sapna · Accepted Answer

Hi @timoyd , there are different ways to solve your problem I have mentioned the 4 of them depending upon the requirement.Please have a look and let me know if you have any other requirement.

Thanks.

First 2 methods will provide you files and tabs bases on types available and the other two will categorize the types in STO and others and will provide you 2 files or tabs. In case of csv you will get separate files and for xlsx you will get tabs.

I hope this helps.

Thanks.