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