| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace w/ name change
I have a workbook that I use month to month named "Report
MTH YY" This month the report is named "Report Jul 04". Next month the report will be renamed "Report Aug 04", then "Report Sep 04" etc. I have formulas that reference last months report. As simple as " ='[REPORT Jun 04.xls]Sheet 1'!A1". Next month in "Report Aug 04" I want the formula to reference the Jul report i.e. ='[REPORT Jul 04.xls]Sheet 1'!A1" . I am looking for a way to automate the process rather than manually using "Find & Replace", but I do not know how to get the month names to change automatically. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the color coding with Find & Replace? | Excel Discussion (Misc queries) | |||
| Change Default Setting-Find & Replace-How? | Excel Discussion (Misc queries) | |||
| why can't I change the date with find and replace in this formula | Excel Worksheet Functions | |||
| Change Excel Find & Replace Options Defaults | Excel Discussion (Misc queries) | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
Threaded Mode
