hi I search macro it create the sheet based on current year in this case 2021 year and creat the headers . their names based on months JAN,FEB up to DEC and show all of files are modified date for any file based on current month for instance if I open file in this month and closed it will modified based on current month JAN and so on for the rest of months , if I open the file in FEB and I have ever opened file in JAN then delete from list of JAN month and move to FEB month and when finish 2021 and enter next year 2022 then should create another sheet is 2022 YEAR and create the headers and get list the files with considering should show hyperlink for the files name in second column for each month to open the file . the macro should run from the first sheet then it will create the sheets.
last thing this is my directory "D:\files" contains many folders and all of the folders contain many differnt extensions files .
this should be when run the macro
thanks in advance
last thing this is my directory "D:\files" contains many folders and all of the folders contain many differnt extensions files .
this should be when run the macro
| 4.xlsx | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | |||
| 1 | JAN | FEB | MAR | ||||||||||||
| 2 | ITEM | FILE NAME | MODIFIED DATE FILE | ITEM | FILE NAME | MODIFIED DATE FILE | ITEM | FILE NAME | MODIFIED DATE FILE | ||||||
| 3 | 1 | AA1.PDF | 01/01/2021 03:10:22AM | 1 | REPORT1.XLS | 02/01/2021 01:10:22AM | |||||||||
| 4 | 2 | AS.JPG | 01/02/2021 02:20:02AM | 2 | REPORT12.XLSM | 02/02/2021 01:20:02AM | |||||||||
| 5 | 3 | AM.DOCX | 01/03/2021 01:30:02AM | 3 | LL.XLSX | 02/03/2021 02:30:02AM | |||||||||
| 6 | |||||||||||||||
| 7 | |||||||||||||||
| 8 | |||||||||||||||
| 9 | |||||||||||||||
2021 YEAR | |||||||||||||||
thanks in advance
