Hello,
I am trying to create an automation where a bot will go into a specified folder and run through a for each file loop and consolidate the data from each Excel workbook into one main file. The data in each workbook is formatted the same, I just need to consolidate all the rows in each file into one main file. I have the for loop and append ranges created. My issue (as far as I can tell) is that the sheet names are all different, so when the bot runs it tries to find “Sheet 1” when there isn’t one. The sheet names are essentially the same as the workbook names, only there are one or two letters chopped off at the end (see below screenshot). Is there a way in StudioX to specify the specific sheet for each file so that the append range will pick up the data and append it to the main workbook?