Updating Information in all worksheet.
I running into a few problems.
1. When I type in the linking formula and press enter, the formula remains
in the cell.
2. When it does work, it is not formatting the information the way I have it
in the masterlist. If I have the information on two lines, it combines it
into one line. If I try to edit it, the formula remains in the cell.
"Gary''s Student" wrote:
Use linking formulas:
=Mastersheet!M34
--
Gary''s Student - gsnu200855
"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.
|