Find and Replace in formulas

Not as slick as the original 'Formulas Only' option, but this Find Replace in Formulas Automator Service (Dropbox download) offers the same general functionality using simple AppleScript.

Install by double-clicking the downloaded .workflow package, giving permission if necessary at System Preferences > Security & Privacy and making sure both Numbers and Automator are listed and checked at System Preferences > Security & Privacy > Privacy > Accessibility. This all takes about a minute.

Then, in a copy of your table (always a good idea to try on a copy to make sure it's doing what you want, select cells where to change the formulas and answer the two prompts.

As Barry points out, though, you might want to consider reworking your document so you don't have to change formulas.

SG

It is likely possible to accomplish this using INDIRECT, rather than having to edit using Find/Replace (in an environment where Find/Replace does not currently work).

Your image seems to indicate that a cell behind the displayed formula is the active one. Since this is the cell for Average hours per day for February, 2018, I'm curious as to the names of the Sheet and Table which would contain this information.

Can you provide further information regarding the structure of your document.

How many Sheets?

Names of the Sheets? Individual, and ones that follow a pattern in their naming.

Table names on the sheet(s) from which the 2019 data is to be collected.

A screen shot of one of the data tables, showing the row and column reference tabs would also be useful.

Regards,

Barry

You could use INDIRECT like this:

For starters:

Adjust this formula for the 3 other values of the month.

And then fill the four cells per month down and right.

Paul.