VBA Code to Sum Same Cell from Multiple Sheets

[KhanofTarkir]

Hello, I am just starting to learn VBA to do some sales analyses.

Does anyone have VBA code that I could use in a module to sum all the values from the same cell in multiple sheets (i.e. cell C16 in US, EU, Canada sales worksheets) into a final master sheet?

I am guessing that the code would require me to enter in the number and names of the sheets I want to sum from, the cell that I want to sum, and the destination master sheet with the final sum.

I am very new to VBA so any help would be greatly appreciated!

Thank you.

 

[pgc01]

Does anyone have VBA code that I could use in a module to sum all the values from the same cell in multiple sheets (i.e. cell C16 in US, EU, Canada sales worksheets) into a final master sheet?

Hi

Just a remark: do you really want to do it in vba?

Since the worksheets are contiguous you could use a 3D formula and add the cells directly:

=SUM(US:Canada!C16)