Dynamic Totals after Load To

OldCityCat

New member
Joined
Apr 24, 2017
Messages
6
Reaction score
0
Points
0
Location
St Augustine FL
Excel Version(s)
2016
Does any one know a way to add a total row and sum the same 1 or 2 columns after query has run and loaded?

Thanks in advance for any and all suggestions

OldCityCat
 
What do you mean by "the same 1 or 2 columns"? You can add a totals line to the table - it should stay intact when you refresh the query and update.
 
I would agree with Ali here. Load the table to the worksheet, go to the Table Design tab and in the Table Style options group, check the "Total Row" box.

Personally, I'd rather leave the output without totals, then feed that to a PivotTable as it's fully dynamic for new data at that point anyway.
 
Back
Top