I have question related to batch macro setup:
I have a table (sourced from excel sheet) containing set of data (let's name it "to be corrected".
I also have set of corrections to the first table, but these are not in one table, but in multiple tables saved in excel file in a way that corrections for each field are saved in separate tab.
The task is to implement corrections for each field (simple way, using Find Replace tool)
I managed to do it transposing the "to be corrected" table in a way that I have field names in one column and the values in the other; then I used separate workflow to combine corrections into a single table (let's name it "corrections") also structured in the same way.
Then I created batch macro which filter matching field names then do Find Replace on values, each iteration for another field name.
But I wonder if I can skip the part of combining corrections into one table and set up the batch macro in a way that for each iteration it refers to the other tab from the excel file instead?
Probably it is manageable if I will put the excel file containing corrections inside the macro and then setting the control parameter that it changes the part which refers to the specific tab, but I would like to have a control over which file is chosen as a source of corrections as well.
Is it possible to set it up the way I would like?
