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: datacostSheet NameA810SteelD420SteeldatacostWoodB910WoodB1020Woodnew datacostWood 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 sheets.yxzp

Batch Macro to combine all sheets and sheet names

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

sheets.yxzp

Data Investigation

Accepted answers

binu_acs

@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

Combine_Sheets_220523.yxzp

All comments

FrederikE

Hey @BRRLL99,

You can tick the option in the macros input tool to show the file name. Then the macros output will include this.

sheets.yxzp

BRRLL99

rows should take sheet name

not file name

binu_acs

@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

Combine_Sheets_220523.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703