Directory input and daily worksheet name variation

[MarkMcCullagh]

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 solution]

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.

[MarkMcCullagh]

Hi Patrick

It was for a dynamic name. Sorry I missed your post. Found a coworker elsewhere in my organisation that provided a solution. Because of my set up I can't post it other than a screenshot. This was his solution.