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