Hi again,
I have a formula in one excel file that references a separate excel file. This issue is the file that is referenced changes each time it's downloaded to something like "file_name_MMDDYYYY". I found something similar -https://www.mrexcel.com/board/threads/referencing-file-to-open-with-partial-name-changing.1177202/#post-5725984, which would work; however how do I get around having multiple versions of the file that is referenced? What I really need to be able to do is reference the last saved occurrence of "file_name_".
To keep it simple, as an example my formula would be
Can what I'm asking even be done? I'm trying to avoid making sure those who use this are using the last instance of the file.
I have a formula in one excel file that references a separate excel file. This issue is the file that is referenced changes each time it's downloaded to something like "file_name_MMDDYYYY". I found something similar -https://www.mrexcel.com/board/threads/referencing-file-to-open-with-partial-name-changing.1177202/#post-5725984, which would work; however how do I get around having multiple versions of the file that is referenced? What I really need to be able to do is reference the last saved occurrence of "file_name_".
To keep it simple, as an example my formula would be
Excel Formula:
=IF([Has_Has_Not_Taken_Report_09172021.xlsx]Sheet1!$E$191="incomplete",TRUE,FALSE)
Can what I'm asking even be done? I'm trying to avoid making sure those who use this are using the last instance of the file.