I have 60+ workbooks which I need to run through a workflow, one at a time. I have attempted utilizing the input "filepath\*.xlsx" where each of the inputs are currently housed, however this appears to only run the first file through the process, despite the schema being exactly the same for each of the 60+ input files.
Within the workflow I (am attempting to):
1) total a number of columns within a new row at the bottom
2) pull in one row of data from a separate input file (added at the bottom of the excel sheet)
3) total these two rows in a third new row of data
4) add percentages for each of the totals within step 3
4.5) Following this, for each individual workbook, I need to iteratively add the totals from step 3 above into a new workbook (replicating the workbook utilized as an input in step 2 above). I have not identified how to make this possible.
5) Save the new workbook in a new location, save the workbook that has appended information per step 4.5 above
6) Move to the next input workbook and start at step 1 above
I am not certain of how to best pursue these actions. I have attached an example of what I am looking to do. NOTE: while in the example these are separate sheets of the same workbook, in actuality the inputs and outputs are all separate workbooks.
A)"Input Example" - an example of one of the 60+ input workbooks as it currently stands
"Input 2 example" - an example of the workbook utilized in step 2 above as an input to each individual workbook (input example shows Job "ABC1" in column J; so the workflow reads "Input 2 example" and pulls in the totals in the row cooresponding with Job ABC1")
C)"Indv. output example" - example of the individual workbook outputs after being pulled in through process steps 1-6 above (totals from the current report provided below the data; Previous totals pulled from input 2 example workbook; these two rows totaled; percentages of obligations provided in last row)
D) "Final totals" - example of the workbook referenced in step 4.5 above (pulls the final total from each individual workbook into the spreadsheet as an appended row, saves and closes/waits for the next input workbook
None of this is currently working. I believe I have errors in my logic throughout the workflow, however the largest of these currently is not being able to iteratively perform the same action for numerous spreadsheets (and save these individually/get the extra "totals" output workbook)
