xlTotalsCalculationSum

**paulqsource** · 04-06-2020, 06:23 AM

ActiveSheet.ListObjects("Table_pastel_12_cust_rank").ListColumns("2019-032"). _
TotalsCalculation = xlTotalsCalculationSum

Hi there

below is my macrofrom a sheet where i import data from mysql database. the field names are not always the same and keeps changing. thus above example will not help me.

I need something like to make the calculation - show totals auto sum for column c.

ActiveSheet.ListObjects("$C").ListColumns("$C"). _
TotalsCalculation = xlTotalsCalculationSum

Please Login or Register  to view this content.

**AlphaFrog** · 04-06-2020, 07:07 AM

Please Login or Register  to view this content.

**paulqsource** · 04-06-2020, 08:34 AM

Thanks you thank you - worked 100%

**AliGW** · 04-06-2020, 08:38 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As yo u re new here, I have done it for you this time.)

https://www.ozgrid.com/forum/index.p...alculationsum/

**paulqsource** · 04-06-2020, 09:25 AM

Hi there

Same query different problems.

As i learns you cannot add to first query if it is a different problem all together?

**AliGW** · 04-07-2020, 08:05 AM

Post #1 in this thread:

Hi there

below is my macrofrom a sheet where i import data from mysql database. the field names are not always the same and keeps changing. thus above example will not help me.

I need something like to make the calculation - show totals auto sum for column c.

From your thread on OzGrid:

Hi there

below is my macrofrom a sheet where i import data from mysql database. the field names are not always the same and keeps changing. thus above example will not help me.

I need something like to make the calculation - show totals auto sum for column c.

https://www.ozgrid.com/forum/index.p...alculationsum/

AND on Mr Excel here: https://www.mrexcel.com/board/thread...ation.1129796/

This is called multiple cross-posting: see forum rule #3, which tells you that you are required to declare cross-posts. You did not do so, which is why your cross-posting was reported and I, as a moderator, dealt with it above. All three of these forums have the same cross-posting rule.

Read this to understand why we have an issue with undeclared cross-posting: https://www.excelguru.ca/content.php?184