Hi,

I'm looking for a smart way to manage 15 files. Every file has same structure and more than 30000 rows, less than 65000 .

Every input file has a **column key**. **In output I need a file every distinct value of key**.

Can you help me?

I'm trying to use Autofilter, but how can I get get criteria value of Autofilter. Can be the correct way?

There are others solutions?

**INPUT**

FF1_clone1.csv

key |
Campo1 |
Campo 2 |

22595 |
22595_1_campo1.1 |
22595_1_campo2.1 |

22595 |
22595_1_campo1.2 |
22595_1_campo2.2 |

23222 |
23222_1_campo1.3 |
23222_1_campo2.3 |

FF1_clone2.csv

key |
Campo1 |
Campo 2 |

22595 |
22595_2_campo1.1 |
22595_2_campo2.1 |

23222 |
23222_2_campo1.2 |
23222_2_campo2.2 |

23222 |
23222_2_campo1.3 |
23222_2_campo2.3 |

FF1_clone3.csv

key |
Campo1 |
Campo 2 |

22595 |
22595_3_campo1.1 |
22595_3_campo2.1 |

23222 |
23222_3_campo1.2 |
23222_3_campo2.2 |

23227 |
23227_3_campo1.3 |
23227_3_campo2.3 |

**OUTPUT**

FF1_22595.xls

key |
Campo1 |
Campo 2 |

22595 |
22595_1_campo1.1 |
22595_1_campo2.1 |

22595 |
22595_1_campo1.2 |
22595_1_campo2.2 |

22595 |
22595_2_campo1.1 |
22595_2_campo2.1 |

22595 |
22595_3_campo1.1 |
22595_3_campo2.1 |

FF1_23222.xls

key |
Campo1 |
Campo 2 |

23222 |
23222_1_campo1.3 |
23222_1_campo2.3 |

23222 |
23222_2_campo1.2 |
23222_2_campo2.2 |

23222 |
23222_2_campo1.3 |
23222_2_campo2.3 |

23222 |
23222_3_campo1.2 |
23222_3_campo2.2 |

FF1_23227.xls

key |
Campo1 |
Campo 2 |

23227 |
23227_3_campo1.3 |
23227_3_campo2.3 |