sum the data in cell of excel

[ramanavg]

Help Needed.

Hi All,

I'm new to vb. I have the data like this. I need to some the data in the next cell once data is populated there. I need summing the logic for a macro to populate this in excel. Because the data is populated dynamically from other sheets.

ex:
--

oprdate sttl_type hr1 hr2 hr3 hr4
01/01/06 s14 10 290 130 490
01/01/06 s14 50 220 320 420
01/01/06 s14 60 210 330 140
01/01/06 s14 70 30 30 0
01/01/06 s14 20 120 30 410
01/01/06 s14 90 120 30 140

total 300 990 870 1600

Your help is greatly appreciated.

Thanks & Regards,
Ramana.

 

[ramanavg]

Help needed to sum cell.

Hi,

I've posted a question yesterday pls help me out.

your help is greatly appreciated.

Thanks,
ramana.