I have an Excel worksheet loaded with linking formula's to other spreadsheets. This totals my departments monthly progress. My issue is that I need to change the formula's each month to point to the correct worksheets. I assumed find and replace would do the trick but it is extremely slow and locks up.
I am thinking that using a marco to swapout my formulas might be better.
So I am looking to search the entire worksheet searching for "Dec_" and swapping for "Jan_"
Can anyone assist with writing me a macro to do so?
Worksheet goes from A1 to U73