Reference the most recent Excel workbook when multiple filenames in a single folder include a common prefix
Posted on 2014-12-16
When writing a formula in Excel (2013) which references content from a different worksheet, is there a way to:
a) use wildcards for part of a referenced filename?
b) reference only the most recent file with a common filename prefix?
For example, suppose you have a folder which contains the following files:
…and in which a new up-to-date "Content…" file is created each weekday from the previous day's file (by File > Save As...) with the last eight characters in its filename designating the date it was created.
Suppose also that the workbook, "Report.xlsx", contains the following formula:
Is there a way to include a wildcard or modify the formula some other way, so that it always looks in the most up-to-date "Content_…" workbook?