#1
|
|||
|
|||
Urgent help regarding automation.
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 |
#2
|
|||
|
|||
Can you post an example (xl file) to make it more clear?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table of contents automation through VB 6.0 | Developer | Word | 0 | 06-09-2009 06:30 AM |
Urgent help! | captainspi | Word | 2 | 04-19-2009 11:17 AM |
What is Application Automation and How can I use it in VBA | KramerJ | Excel | 0 | 03-30-2009 12:59 PM |
COM Automation Errors | ivanm | Word | 0 | 03-23-2009 07:02 PM |
Notification Mail In project server - Plz help urgent | myanilkumar | Project | 0 | 01-19-2006 05:44 AM |