hello
I seek for macro to create the whole data as what shows in the pictures . my directory is D:\FOLDER . This directory contains many folders and subfolders and different extensions files .
this is the orginal data
when selet fro D2 should create the whole data by brings the names folders and subfolders and brings the files under folder name & subfolder name with create the hyperlink whether folders or files names to open it
and if select D2,E2 together then should brings the files based on modified date
thanks in advance
I seek for macro to create the whole data as what shows in the pictures . my directory is D:\FOLDER . This directory contains many folders and subfolders and different extensions files .
this is the orginal data
FOLDERS.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | extensions | month | |||||||||
2 | |||||||||||
3 | |||||||||||
4 | |||||||||||
5 | |||||||||||
6 | |||||||||||
7 | |||||||||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
12 | |||||||||||
SHEET3 |
when selet fro D2 should create the whole data by brings the names folders and subfolders and brings the files under folder name & subfolder name with create the hyperlink whether folders or files names to open it
FOLDERS.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | extensions | month | |||||
2 | |||||||
3 | FOLDER NAME | ||||||
4 | INVOICES | ||||||
5 | ITEM | FILE NAME | MODIFIED DATE | CREATED DATE | PATH | ||
6 | 1 | INV-A100 | 01/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES | ||
7 | 2 | INV-A101 | 02/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES | ||
8 | 3 | INV-A102 | 03/06/2021 | 20/07/2021 | D:\FOLDER\INVOICES | ||
9 | 4 | INV-A103 | 04/06/2021 | 20/07/2021 | D:\FOLDER\INVOICES | ||
10 | |||||||
11 | SUBFOLDER NAME | ||||||
12 | REPORT | ||||||
13 | ITEM | FILE NAME | MODIFIED DATE | CREATED DATE | PATH | ||
14 | 1 | REP-200 | 01/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES\REPORT | ||
15 | 2 | REP-201 | 02/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES\REPORT | ||
16 | 3 | REP-202 | 03/06/2021 | 20/07/2021 | D:\FOLDER\INVOICES\REPORT | ||
17 | 4 | REP-203 | 04/06/2021 | 20/07/2021 | D:\FOLDER\INVOICES\REPORT | ||
SHEET3 |
and if select D2,E2 together then should brings the files based on modified date
FOLDERS.xlsm | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | extensions | month | |||||
2 | MAY | ||||||
3 | FOLDER NAME | ||||||
4 | INVOICES | ||||||
5 | ITEM | FILE NAME | MODIFIED DATE | CREATED DATE | PATH | ||
6 | 1 | INV-A100 | 01/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES | ||
7 | 2 | INV-A101 | 02/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES | ||
8 | |||||||
9 | SUBFOLDER NAME | ||||||
10 | REPORT | ||||||
11 | ITEM | FILE NAME | MODIFIED DATE | CREATED DATE | PATH | ||
12 | 1 | REP-200 | 01/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES\REPORT | ||
13 | 2 | REP-201 | 02/05/2021 | 20/07/2021 | D:\FOLDER\INVOICES\REPORT | ||
SHEET3 |
thanks in advance