Re: $$Excel-Macros$$ Dynamic formula
Ashsih, Format of file is attached but no data On Sat, May 21, 2011 at 8:29 AM, Skanda skanda.pokkun...@gmail.com wrote: On Sat, May 21, 2011 at 12:39 AM, ashish koul koul.ash...@gmail.comwrote: can you attach the sample file On Fri, May 20, 2011 at 10:07 PM, Skanda skanda.pokkun...@gmail.comwrote: 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 http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 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
On Sat, May 21, 2011 at 12:39 AM, ashish koul koul.ash...@gmail.com wrote: can you attach the sample file On Fri, May 20, 2011 at 10:07 PM, Skanda skanda.pokkun...@gmail.comwrote: 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 http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 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
$$Excel-Macros$$ Dynamic formula
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
Re: $$Excel-Macros$$ Dynamic formula
can you attach the sample file On Fri, May 20, 2011 at 10:07 PM, Skanda skanda.pokkun...@gmail.com 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 http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 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