Thank you for the reply Macropod.

I will have a read of this in more detail.

What I am looking for is a macro that I can assign to a button in th word document that will take data from specific fields and populate an excel document register, placing the appropriate data into specific columns at the bottom of the excel table. The word form has a lot more information than the register requires.

Would it be better if I posted the two files on here so you can see the information I need to export from word?