Prevent Excel write to recreate the sheet

It looks to me like you need to use Excel Pivot Table and Named Range.
This would require excel to use a dynamic range

1 Like