Global file reference change

[Ronen Ben-Hai]

I have two spreadsheets, one tracking expenses, the other tracking income.
The income sheet(12 pages, 1 for each month) also has a column for each day
of the month to show the expenses for that day/month. It references the
expenses file. My problem is this: I have a template for each, blank, that
each year I rename for the year. This means I have to go in and edit each
cell for 12 months x 30 days...360 cells, and change the file reference to
show the new expenses file. Is there any way to do a global find and
replace for the entire income sheet to make this/these changes?

Sorry if I haven't put this well. I'm new to anything but basics.

Ronen
Jupiter, FL
USA

 

[Gord Dibben]

Ronen

Assume you have the new Expenses workbook saved for say 2004.

Open a copy of the Income workbook and Edit>Links>Change Source. Point to the
2004 Expenses workbook and Close.

Gord Dibben XL2002

 

[Ronen Ben-Hai]

Unreal!!! Worked like a charm. Can't thank you enough. This has been
busting my (#% for a while now.

Ronen

Ronen

Assume you have the new Expenses workbook saved for say 2004.

Open a copy of the Income workbook and Edit>Links>Change Source. Point to the
2004 Expenses workbook and Close.

Gord Dibben XL2002