Render report with merged headings and to multiple excel spreadsheets

[CBshaw]

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.

[binuacs]

@CBshaw one way of doing this

[Qiu · Accepted solution]

@CBshaw 
We can so this without macro as below

[CBshaw]

Thanks to both of you!!

[Qiu]

@CBshaw 

Glad to be any help.