ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   To sort Excel files. (https://www.excelbanter.com/excel-worksheet-functions/208332-sort-excel-files.html)

[email protected]

To sort Excel files.
 
Hi,

I have got 100 excel files in a folder.
Out of this 60 files are of type A and 40 of type B.
How can I copy the files of type A alone to a folder and similarly
typeB to another folder based on the difference in the text in a
particular cell say B16.

Thanks,

Shaiju


All times are GMT +1. The time now is 01:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com