Monthly Data Changes

[pclplante]

I have a workbook that I keep track of production by day and the workbook is the name of the month. The formula I want to change is getting data from another workbook. It is ='\\Nenhexe01\Administrative\Reports\DailyProduction\2011\DCT\[Sep 11_STB Production Summary-2nd Shift.xlsx]31'!$F$83
What I'm looking for is to be able to change the month from Sep to the next month until the end of the year then I'll need to change the years and not the month from then on. Is there an easy way to do this without having to manually change it every month or year for every day of the month?

 

[jbeaucaire]

You can highlight all the cells where you want to change this part of the formula, then use Excel Search/Replace function (CTRL-H) to make the change for you.

Just make sure you are searching for "partial matches" and that you are searching in formulas, not values.

 

[pclplante]

Thanks I'll try it when I get to work today.