Hi All,

I am looking to develop a macro that does a find and replace based on a specific date in a cell. The model compares actuals to forecast values and depending upon the month references a specifc file path. I can list the file path in an excel sheet that it can reference from, but essentially it would have to replace specific cells in specific sheets. I guess I could do name ranges and also put them in a table that it would reference. Does anyone have a solution to this?