Combine Multiple Table Into Sheets In One Excel

[SyamaliaFaiqah01]

Hi, I want to ask how can we combine 9 different tables with different structures into sheets in one single Excel file. Plus, how to put DateTimeNow in the Excel file name after the run?

[flying008]

Hi, @SyamaliaFaiqah01 

Could you please upload some table data of sample in your case ? and show the result as your want.

[SyamaliaFaiqah01]

These are the sample inputs and the result I want.

[binu_acs]

@SyamaliaFaiqah01 This can be done using batch macro

[SyamaliaFaiqah01]

Thank you!