This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The main workflow just passes the bookname/range string to the control parameter of the macro
For each Book/Range record passed in to the macro, the 2 action tools update the file path and add a variable to the result with the range information so you can keep track in the main workflow. The macro is set up so that the result columns can vary between iterations. For the sample I've set up, here are the results
I set up the column names in the 3 Excel workbooks to reflect their respective book and sheet names. The attached package contains all the sample excel sheets as well
Thanks! Would that then just add the new named columns in the index as additional columns? If so, is the output additional columns aligned to the other columns or would they be as separate rows? I am asking as I would prefer the former.
I can also test this at my end but though I'd ask on the forum too!