hello
I know this question is very complicated so I have many files are different in files extensions each one of them contains folder its names are matched with the headers in the main directory is "E:\SUMMARY" the folder summary contains many folder based on current year 2020,2021.... and so on the folder " current year " contains many folders it's names based on the headers are PDF,AVI, DOCX as in my picture and the pictures are in this directory "E:\images" and contains many folders contain the images the folders which contain images its names the same headers .
so what I want create sheets based on current year should be like this " summary files 2021 " and if folders ' names which contain files are matched with headers' names which contain files extension then brings the files under the headers which contain files extension and if the folders ' names which contain images are matched with headers' names which contain ICONS then brings the images under the headers which contain ICONS and fit in the cell and hyperlink the images then when press the image open the file
the headers starts from COL A: V and increasable
thanks in advance
I know this question is very complicated so I have many files are different in files extensions each one of them contains folder its names are matched with the headers in the main directory is "E:\SUMMARY" the folder summary contains many folder based on current year 2020,2021.... and so on the folder " current year " contains many folders it's names based on the headers are PDF,AVI, DOCX as in my picture and the pictures are in this directory "E:\images" and contains many folders contain the images the folders which contain images its names the same headers .
so what I want create sheets based on current year should be like this " summary files 2021 " and if folders ' names which contain files are matched with headers' names which contain files extension then brings the files under the headers which contain files extension and if the folders ' names which contain images are matched with headers' names which contain ICONS then brings the images under the headers which contain ICONS and fit in the cell and hyperlink the images then when press the image open the file
the headers starts from COL A: V and increasable
thanks in advance
Last edited: