Re: $$Excel-Macros$$ Dynamic formula

[Skanda]

Ashsih,
Format of file is attached but no data
On Sat, May 21, 2011 at 8:29 AM, Skanda  wrote:

>
>
> On Sat, May 21, 2011 at 12:39 AM, ashish koul wrote:
>
>> can you attach the sample file
>>
>>
>> On Fri, May 20, 2011 at 10:07 PM, Skanda wrote:
>>
>>>  There are two data files say temp1_mon.xls and
>>> temp2_monyyy.xls.these two data files change everymonth i.e temp1.xls is
>>> always the current data month and temp2.xls is previous data month.
>>>
>>> here monyyy is displayed as APR2011 for current month and MAR2011 for
>>> previous month.
>>>
>>> There is a tab called MEMO in temp1_mon.cls where the cell
>>> reference(4,6) is calculated as:
>>>
>>> (sum of column 10 from minus sum of column 9 from current month file )
>>> minus sum of column 10 from previous month file.
>>>
>>>
>>> So the file which is current month will become prior month for the next
>>> month run. Help me to make the formula dynamic.
>>> VB code can do this?
>>>
>>> --
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>  --
>>
>> --
>> 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


Temp_APR2011.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


Temp_MAR2011.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Dynamic formula

[Skanda]

On Sat, May 21, 2011 at 12:39 AM, ashish koul  wrote:

> can you attach the sample file
>
>
> On Fri, May 20, 2011 at 10:07 PM, Skanda wrote:
>
>>  There are two data files say temp1_mon.xls and
>> temp2_monyyy.xls.these two data files change everymonth i.e temp1.xls is
>> always the current data month and temp2.xls is previous data month.
>>
>> here monyyy is displayed as APR2011 for current month and MAR2011 for
>> previous month.
>>
>> There is a tab called MEMO in temp1_mon.cls where the cell
>> reference(4,6) is calculated as:
>>
>> (sum of column 10 from minus sum of column 9 from current month file )
>> minus sum of column 10 from previous month file.
>>
>>
>> So the file which is current month will become prior month for the next
>> month run. Help me to make the formula dynamic.
>> VB code can do this?
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> 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

Re: $$Excel-Macros$$ Dynamic formula

[ashish koul]

can you attach the sample file

On Fri, May 20, 2011 at 10:07 PM, Skanda  wrote:

> There are two data files say temp1_mon.xls and temp2_monyyy.xls.these
> two data files change everymonth i.e temp1.xls is always the current data
> month and temp2.xls is previous data month.
>
> here monyyy is displayed as APR2011 for current month and MAR2011 for
> previous month.
>
> There is a tab called MEMO in temp1_mon.cls where the cell
> reference(4,6) is calculated as:
>
> (sum of column 10 from minus sum of column 9 from current month file )
> minus sum of column 10 from previous month file.
>
>
> So the file which is current month will become prior month for the next
> month run. Help me to make the formula dynamic.
> VB code can do this?
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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$$ Dynamic formula

[Skanda]

There are two data files say temp1_mon.xls and temp2_monyyy.xls.these
two data files change everymonth i.e temp1.xls is always the current data
month and temp2.xls is previous data month.

here monyyy is displayed as APR2011 for current month and MAR2011 for
previous month.

There is a tab called MEMO in temp1_mon.cls where the cell
reference(4,6) is calculated as:

(sum of column 10 from minus sum of column 9 from current month file ) minus
sum of column 10 from previous month file.


So the file which is current month will become prior month for the next
month run. Help me to make the formula dynamic.
VB code can do this?

-- 
--
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