update text from ons sheet to another.

H

Hannes

Hi
I have a workbook with a number of sheets, the first sheet I want to use as
a master sheet from which I want to do changes and automataccally update
other sheets should I change anything. I can do formulas and values but I
have a problem with "text". EG if I change a persons name or item description
on the first page it must update other cells with same info??
 
S

Spiky

Hi
I have a workbook with a number of sheets, the first sheet I want to use as
a master sheet from which I want to do changes and automataccally update
other sheets should I change anything. I can do formulas and values but I
have a problem with "text". EG if I change a persons name or item description
on the first page it must update other cells with same info??
Click to expand...

Formulas work on text, too.
 
Top