hi professional
i hope finding what I look for it . what I want filtering file names in folders and subfolders for this directory "C:\files" based on cell value in F3 the sheet name is file extension. it should match file extension in F3 with sheet name .if I write file extensions . then should filter and copy files names for each sheet based on extension type .
and should be each 30 files into three columns with hyperlink the files under header FILES and open and copy to the bottom for each 30 files are divided for each 10 individually
original data in sheet name "PDF" and so on for all extensions as show in the sheets .
EXPECTED RESULT
please don't forget match F3 with sheet name as mark by highlight color
i hope finding what I look for it . what I want filtering file names in folders and subfolders for this directory "C:\files" based on cell value in F3 the sheet name is file extension. it should match file extension in F3 with sheet name .if I write file extensions . then should filter and copy files names for each sheet based on extension type .
and should be each 30 files into three columns with hyperlink the files under header FILES and open and copy to the bottom for each 30 files are divided for each 10 individually
original data in sheet name "PDF" and so on for all extensions as show in the sheets .
EXPECTED RESULT
please don't forget match F3 with sheet name as mark by highlight color