I have a workflow which iteratively works through numerous "JOBS" and performs a function on each. Once complete, in addition to the output file for each, I need to append the second to last row's information to a new workbook. These are "current totals" for the "Job", under a few columns.
For an example, I am attaching a workbook with numerous tabs. My inputs may number above 75 files, but for this purpose I am showing two, and an example of what the output will look like.
Final results of my workflow will look similar to those in the attached tab "Example Job ABC1 Output" and "Example Job DEF21 output"; my workflow now saves each of these as an individual workbook.... I need to take the second to last row of each, (row stating "CURRENT TOTAL"), and append it to a separate workbook which will be set-up such as the tab "Example AMERNDMENT WORKBOOK".
As the workflow goes through JOB "ABC1", I need to append the totals in row "CURRENT TOTAL" in accordance with the columns in "Example Amendment". When my workflow moves on to JOB "DEF21" and gives the output, I need it to append below job ABC1 on the same file.
I hope this makes sense.
*within the attachment I have left "sheet 1" and "example prev. data" in case an understanding of where the totals under the outputs assists in the logic.
I have tried playing with the transpose function/etc. with no avail.
