From one village idiot to another (I'm offering a virtual high five). If I
understand your question, you want to type in, say a policy number, in "Sheet
1" and have that entry reflected in "Sheet 2", "Sheet 3", etc. in which ever
cell you choose in each sheet.

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


"willie091028" wrote:

I think this question was already addressed, but you're dealing with the
village idiot here . . . the answers didn't make sense to me.

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.