Batch Macro

mquast

I am trying to create a more flexible option that allows a control workbook to select which tables it'll do the transformation to. I am stuck on trying to convert the old transformation process into a batch macro so that it can adjust to have more or less than 6 tables imported. 

Control.yxmd

test.xlsx

binu_acs

@mquast Attaching the batch macro which will combine all the sheets data with the sheet name, so based on the sheet name you can apply your logic to the combined output

Control.yxzp