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