Consulting

Results 1 to 20 of 28

Thread: create sheets based on extensions files and copy to each months

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    create sheets based on extensions files and copy to each months

    hello
    I hope finding in this forum what I 'm looking for despite what I'm asking it not easy I need some experts to achieve my project
    my known in vba is not advanced but I can deal with codes and amending some details to what I need but writing the code absolutely I can't ,so what I want create sheets based on names in folders my directory is "D:\files" and the folder file contains many many subfolders names XLSM,XLS, XLSX,PDF,DOC,PPT,MP4,AVI ,TEXT....etc and increasable and each sub folders contain the files
    after create the sheets it brings all the files from subfolders to the sheet name based on contain from extension file for instance the files pdf should copy to sheet pdf and copy the files to specific month if I issue files in JAN then copy to COL JAN for all files from all subfolders and so on the rests of months
    by the way I also issued in this forum
    https://www.excelforum.com/excel-pro...ch-months.html
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •