Excel Automation

Copper Contributor

Hi All, 
Is there a way to automatise this workflow from excel: 
Take (and in best case Look for) always the newest CSV File from folder 
look For the same Attributes in a specific column / only two "categories" 

Copy one Category

Paste in a new File 
Delete from the "Big" File 
Save both as a new CSV on a specific folder 

I hope there is a solution to this. 
Thank you for your input! 

 

0 Replies