Need Macro to Fill Database with Form Info

Hello All

I would greatly appreciate some assistance. I am new to Macro's, but eager to learn.

I have attached a form that will be filled out routinely. I am wanting to assign a Macro to the button in the top right corner that will do the following:

1. Print the form.
2. Copy the entries from the form into the "Database" sheet as shown.
3. Blank the grey cells in the "Form" Sheet.
4. Change the value in J3 in the "Form" Sheet from TR0001 to TR0002.

I only now how to make Macro's with the "Record" function, and that won't work with Copy & Paste, so I'm needing assistance to get this figured out.

If any clarrification is needed, please let me know. If the structure I have created is not great for Macros, I am open to suggestions, but I am not the end user of the form, so keeping it close to this would be ideal.

NOTE: The end user will have Excel 2003, so hopefully that won't be an issue.