Urgent help regarding automation.

[aligahk06]

Dear All,



I have a workbook with sheet1 (name of sheet qty) and sheet2(name of sheet price)
I want in Sheet2(price) i.e multiplication of qty and price cell by cell and then
sum of each multiplication in a cell.
i.e
Qty.Sheet price sheet
Cell c6:c21 c6:c21
Cell d6:d21 d6:d21
...

upto Cell j6:j21 j6:j21
and so on.
I want multiply (qty C6* Price C6 then qtyC7*PriceC7 ......so on till qtyC21*PriceC21)
In cell C22 sum of all this multiplication.
again (qty D6* Price D6 then qtyD7*Price D7 ......so on till qtyD21*PriceD21)
In cell D22 sum of all this multiplication.


...
...
upto Col (qty J6* Price j6 then qtyJ7*Price J7 ......so on till qtyJ21*PriceJ21)
In cell J22 sum of all this multiplication.

Finally in cell F 26 Sum of all sum i.e sum(c22,d22,e22,f22,........j22)

Hope my problem is clear.

Please assist me either through VBA or through Formula or function or any automated technique.

I have a lot of workbook and it would take time if i would do it manually.


Rgds,

aligahk06