Get sum of the values in corresponding cells.

[shaju]

Hi,
I have values, which changes each day, in range (T12:AA21) in 32 identical sheets viz sheet4, sheet5, sheet6, sheet7 etc. Sheet4 is a "Summary sheet". I want in sheet4 range (T12:AA21) the sum of the values in corresponding cells. Like

Sheet4.range("T11").value= sheet5.range("T11").value+sheet6.range("T11").value+sheet7.range("T11").value+......sheet35.range("T11").value

Sheet4.range("T12").value= sheet5.range("T12").value+sheet6.range("T12").value+sheet7.range("T12").value+......sheet35.range("T12").value

etc. How can it be done through VBA.

TIA

 

[mumps]

Place this formula in cell T12 and copy it across and then down: =SUM(Sheet4:Sheet35!T12)

 

[shaju]

Thanks a lot mumps. That answer was much helpful. (Leave the vba part, this is sufficient. )

 

[mumps]

You are very welcome.