View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
sf sf is offline
external usenet poster
 
Posts: 12
Default 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.