What I have is a workbook with 7 spread sheets. It is a database for an
insurance program. On each sheet I need the named insured, the policy term,
policy number, retro date etc. Is there a way that I can set up a basic info
spreadsheet and copy the info from it to each of the other spreadsheets based
on what that particular spreadsheet requires. So, that I can fill in the
primary info and when I change it have it automatically change on all of the
sheets within the workbook.
Please remember I need step by step directions for a person who is not into
computer jargon and needs everything very basic. My thanks to anyone who can
help me.
Go ahead and type in the policy number in "Sheet 1" and then go to "Sheet 2"
and select the cell where you want the policy number to appear. Now press
the equal sign(=). Next, with your mouse, left click the "Sheet 1" tab and
find the policy number. Left click it and press the "Enter" key. That's it.
If you change the policy number on "Sheet 1" the change will be reflected
everywhere you linked it in this fashion.
--
Y