Global file reference change
 

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

Global file reference change
 

group the sheets and do

Edit=Replace

What: specify the old value
With: specify the new value

Now ungroup the sheets

--
Regards,
Tom Ogilvy


Ronen Ben-Hai wrote in message
.. .
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

Global file reference change
 

If this is another file - an external reference, then go to Edit=Links and
select your file, then do change source.

--
regards,
Tom Ogilvy

Ronen Ben-Hai wrote in message
.. .
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

Global file reference change
 

This worked like a charm. Thanks much.

"Tom Ogilvy" wrote in message
...
If this is another file - an external reference, then go to Edit=Links
and
select your file, then do change source.

--
regards,
Tom Ogilvy

Ronen Ben-Hai wrote in message
.. .
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