Muhammad_Usman
Active Member
- Joined
- Dec 9, 2015
- Messages
- 489
Hey!
Hope you all guy's well, I am working in a sheet index value from other workbook. It working fine. But now i want to index from latest workbook which is downloaded every on hour with new name .
It would be possible that formula change the file name automatics when downloaded in download folder.
Currently I am index / match from highlighted workbook. how file name will replace or update auto with latest one ????
Current work book name = "Paid Message - Summarized R3_638232144732429206"
Replace with lates ie in this exp = "Paid Message - Summarized R3_638232145174314307"
Any Excel Guru here to solve my problem
Hope you all guy's well, I am working in a sheet index value from other workbook. It working fine. But now i want to index from latest workbook which is downloaded every on hour with new name .
It would be possible that formula change the file name automatics when downloaded in download folder.
Currently I am index / match from highlighted workbook. how file name will replace or update auto with latest one ????
Current work book name = "Paid Message - Summarized R3_638232144732429206"
Replace with lates ie in this exp = "Paid Message - Summarized R3_638232145174314307"
Any Excel Guru here to solve my problem