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


--
Mad101daN
------------------------------------------------------------------------
Mad101daN's Profile: http://www.excelforum.com/member.php...o&userid=34674
View this thread: http://www.excelforum.com/showthread...hreadid=544381

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.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=544381

Thank you.

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

Thx

Dan


--
Mad101daN
------------------------------------------------------------------------
Mad101daN's Profile: http://www.excelforum.com/member.php...o&userid=34674
View this thread: http://www.excelforum.com/showthread...hreadid=544381