There are two data files say temp1_monyyyy.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_monyyyy.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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
