I need to create a macro to take the data out of my "sales order form" and put it into specific columns on another sheet and to reset the original order form back to a blank form. There are 9 data sets I want to move from sheet 1. There are a few issues of course, if the customer ordered more than one item on the form some of the columns would remain static as others would repeat...

My data sets are:

Customer #, product discription, discount %, discount amt, net price, date, lease, lease length, lease partner.

The static items would be:

Customer #, date, lease, lease length, lease partner

Those will not change no matter how many items the customer ordered.

I hope I was clear enough in my explanation. Any help is appreciated!!

Thanks!