Render report with merged headings and to multiple excel spreadsheets

Hi,

I need help rendering a report that has a merged heading but also renders to multiple excel spreadsheets based on Group column. I know how to do each separately, but I cannot figure out how to join them correctly.

Sample1.xlsx

Reporting

Accepted answers

Qiu

@CBshaw
We can so this without macro as below

0306-CBshaw.yxmd

All comments

binu_acs

@CBshaw one way of doing this

Render_Sheets_04032024.yxzp

Qiu

@CBshaw
We can so this without macro as below

0306-CBshaw.yxmd

CBshaw

Thanks to both of you!!

Qiu

@CBshaw

Glad to be any help.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703