Re: $$Excel-Macros$$ Automation of formula

2011-05-24 Thread Umesh Dev
Hi,

What's the code you want to pass and to which cell. mention that also

Regards
Umesh Dev

On Mon, May 23, 2011 at 11:32 PM, Skanda skanda.pokkun...@gmail.com wrote:

 The column difference highlighted in green is calculated as the
 difference between the two cells to its left.Then %difference is the
 percentage in their difference and abs difference is their absolute
 difference.

 How to code such that if i pass the formula these three fields are
 calculated for rest of the columns.
 attached is the worksheet.

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Automation of formula

2011-05-23 Thread Skanda
The column difference highlighted in green is calculated as the difference
between the two cells to its left.Then %difference is the percentage in
their difference and abs difference is their absolute difference.

How to code such that if i pass the formula these three fields are
calculated for rest of the columns.
attached is the worksheet.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


EXCEL_ACCESS.xls
Description: MS-Excel spreadsheet