Directory input and daily worksheet name variation

Question

Hi

I get a daily file that is manually pulled and the creator is sticking to a predefined naming convention so that the latest .xlsx file can be read in. The single worksheet name varies and so my question is, is there a way for this to be loaded automatically regardless of this name change ?

Thanks in advance.

Mark

patrick_mcauliffe · Accepted Answer

Do you always know what the sheet name will be?

You can input a list of sheet names from the Excel file, and then use a Dynamic Input to read the correct sheet based on that.

Or you could just create a formula if it is more consistent.

See attached.