transfer data from excel form to a spreadsheet
 

I am trying to do an inventory control in excell. I have a form that
contains customer info along with drop down menues to select product
and quanity. This is in rows. what I need to do is move the data
from a form to a spreedsheet where each column is named all of the
different products so that it takes the quanity ordered out of
inventory and prints a copy of the form.

Unfortunitly I do not understand how to write a macro.