Ok I have a cell that references a workbook titled June Sales.xls and one
cell that references July Sales.xls Is there a way to write a macro that
would check all formulas for any month and replaces it with the current
month. So that if I ran the macro today both the cells above would end up
referencing February Sales.xls?