I keep trying to use the formula suggested but its just not working for me,
the formula just remains in the cell. Is there anything else that should be
present or active when trying to link data.

"Shane Devenshire" wrote:

Hi,

If you are building linked formulas there should be no problem as suggested.

If not you can use Replace against all the sheets in the workbook at once by
selecting all the sheet tabs and pressing Ctrl+H then entering what you want
to replace with what you now want.

A third alternative is to use VBA.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"SF" wrote:

I have information that repeats itself on multiple sheets and when I have to
update the information, I have to go through each sheet to fix the same thing.
I want to know is there a way to automatically update similar information in
multiple worksheets just by changing the information on the Mastersheet.