Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2009, 05:25 AM
aligahk06 aligahk06 is offline Urgent help regarding automation. Windows XP Urgent help regarding automation. Office 2007
Advanced Beginner
Urgent help regarding automation.
 
Join Date: Aug 2009
Posts: 58
aligahk06 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-14-2010, 01:55 PM
BjornS BjornS is offline Urgent help regarding automation. Windows Vista Urgent help regarding automation. Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Can you post an example (xl file) to make it more clear?
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft