Excel / Word Multple Entries- Help please

[Mad101daN]

Hi

I am quite new to excel and would like some help please.

I have to enter the same information (name, address, D.o.B etc) into dozens of forms.

I would like to be able to enter this information once, and then have it copied to all the relevenat forms, and the forms saved as original copies.

So I enter John Smith in Document 1 and then on Documents 2 - 20 I want his name to appear then addresss etc. Each of the 2 -20 documents needs to be saved for future reference.

I hope I am making myself clear.

Hope you can help.

Dan

[mrice]

You should be able to do this with a formula

Go to a cell on the copy sheet, enter = and then use the window menu option to go to the source sheet and select the cell that you want to synchronise with.

[Mad101daN]

Thank you.

Can I use the = command to get data from another excel document ?

Thx

Dan