Hello,
Each month, I run isolated data in their own separate workbooks but I do not change the location of cells from which the data is pulled from. The analysis worksheet that contains my formulas is then move/copied to my new month workbook. The issue I have with Excel 2010, is that I am unable to edit the links in order for the data from the new month to automate. The formula in the new month workbook is pulling from the previous month's data. The only fix is to pain painstakingly go through all the formulas and remove the month name from the previous version as the rest of the formula will work.
Please tell me there is a better way to automatically automate my data for each month?????
Each month, I run isolated data in their own separate workbooks but I do not change the location of cells from which the data is pulled from. The analysis worksheet that contains my formulas is then move/copied to my new month workbook. The issue I have with Excel 2010, is that I am unable to edit the links in order for the data from the new month to automate. The formula in the new month workbook is pulling from the previous month's data. The only fix is to pain painstakingly go through all the formulas and remove the month name from the previous version as the rest of the formula will work.
Please tell me there is a better way to automatically automate my data for each month?????