Hello there!
I have a few workflows that are dependent on excel sheets that come from a offshore team; therefore, I do not have control of formatting. Although most of the times it comes in as "Sheet1", sometimes the team (different people create the report each day) add extra sheets or rename it something else. This creates errors that I have to manually fix each time.
Have you encountered similar challenge? Any idea on how to address it other than trying to get the team to have the same format each day? - I tried that already :)
Hey @Kristie_Pires,
You may need to create a macro but you can import the sheet names of any Excel files dynamically using the input data tool:
Any questions or issues please ask :)
HTH!
Ira