Updating Information in all worksheet.
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.
|