Hi
I have created a batch macro which has combined all the sheets,
in my end output I would like to have additional column from which sheet the rows are arrived.
ex:
data | cost | Sheet Name |
A8 | 10 | Steel |
D4 | 20 | Steel |
data | cost | Wood |
B9 | 10 | Wood |
B10 | 20 | Wood |
new data | cost | Wood |
Sample of my macro has been attached, since i have multiple sheets I would like to create this in a Batch Macro along with sheet names
Solved! Go to Solution.
Hey @BRRLL99,
You can tick the option in the macros input tool to show the file name. Then the macros output will include this.
rows should take sheet name
not file name
@BRRLL99 The batch macro I provided in the previous post has this field File Name, you can extract the sheet name from that field using the regex function