Auto sum

Copper Contributor

Auto sum I have to put the data from 12 data tabs into one final sheet so I have all the data from the 12 sheets 

2 Replies

You can use the Data consolidation

All your tabs must be identical(same columns and rows  order), on the tab you want to get the totals, click on Data --> from the Data tools group --> consolidate 

from the window that will appear add all your tab.

 

 

Thanks I will try it