Adding data from form

[athard]

Hi,

I need help with this unique problem.

I have 2 excel spreadhseets.

Spreadsheet 1: This has a form where people enter data, hit a create button and a word document is created using some of the data they put in. This workbook has 3 worksheets. Sheet 1 is the form, sheet 2 is the data which is used to populate parts of the form (using Vlookup) and sheet 3 has the final letter, which is converted to a word document using a VBA Macro.

Spreadsheet 2: This is a spreadsheet that has only headings right now. I want to make it so that when I hit the "Create" button from spreadsheet 1, it not only creates the word document, but that some fields from the form as well as sheet 3 are copied here. So basically create a new row, and copy that data over here.

Is that possible? I've been searching online all day for VBA codes to help me with this but can't find any. Thanks.

[royUK]

The contacts form example here contains code to copy specific cell values to another sheet

http://www.excel-it.com/vba_examples.htm