Data Transfer-What I would like to be able to do?

[MRSH]

Hi

I wonder if somebody can help, please.

I have two Excel workbooks.

Workbook 1 is a list of 400 names, addresses, and loads of other data going across in rows with column headers.

Workbook 2 is a document. Within this document are several empty fields.

What I would like to be able to do is automate the process of transferring some of the data from Workbook 1 to populate the relevant fields in Workbook 2.

Then I need to print the document in Workbook 2.

Then transfer the data applicable for the next name on the list in Workbook 1 to Workbook 2 - print that - then continue for all 400 records in Workbook 1.

Is there a way I can automate this process?

I hope I've explained that OK!!!

Thanks

Matthew

[pike]

Dude
Look at this example from "John Wallkenbach"

[teylyn]

If your second file is a "document", you may want to consider creating it in Word and doing a simple mail merge with the data from the Excel list.