I hope I can explain this clear enough...
I have a situation reports that are updated everyday into new excel sheets. Three different Companies do this in their own workbook. Then they save the information into a folder with the corresponding month, and then another folder of that day of the month. They likewise change the name of the workbook to reflect the date of the reports. I am trying to build a workbook that will consolidate all three everyday into one summarized report.
Now for my question...
Is there a way to define a workbook reference name using a series of formula results?
ie. I want to pull Cell A1 of the workbook .../September/30/30 SEP A_Co.xls, but also update the next day so that it pulls A1 from .../October/1/1 SEP A_Co.xls.
Any help would make my time more worthwhile, and much easier over here in Iraq! Thanks!
I have a situation reports that are updated everyday into new excel sheets. Three different Companies do this in their own workbook. Then they save the information into a folder with the corresponding month, and then another folder of that day of the month. They likewise change the name of the workbook to reflect the date of the reports. I am trying to build a workbook that will consolidate all three everyday into one summarized report.
Now for my question...
Is there a way to define a workbook reference name using a series of formula results?
ie. I want to pull Cell A1 of the workbook .../September/30/30 SEP A_Co.xls, but also update the next day so that it pulls A1 from .../October/1/1 SEP A_Co.xls.
Any help would make my time more worthwhile, and much easier over here in Iraq! Thanks!