userform macro button problemo
 

ok im making an invoice book for school. AS project.

i hav 2 workbooks but only using one at the moment.
i have a spreadsheet with headings such as Customer name,
no, address etc and product code price quatitiy and
total. The customer details are on one userform and the
product information on the 2nd userform.

If the customer wants to order more than one product they
can click nextand a msg box appears saying "Do you want
to order another product?" "YES" or "NO". if the user
clicks "YES" the 2nd userform appears again and different
product details can be entered.
When finished the details are entered on to the top line
on a spreadsheet. Everytime u have a new customer their
details are entered at the top.

MY PROBLEM...
At the moment if a customer orders more than one product
only the last one they order is recorded.

if the customer orders more than one product I want the
customer details to be entered again onto the second line
of the spreadsheet by the click of a button.
Do u know how I can do this?

Your help will be greatly appreciated!!

userform macro button problemo
 

Try the following, it will duplicate all of row 1

Rows("1:1").Copy
Rows("1:1").Insert shift:=xlDown
Application.CutCopyMode = False

Cheers
Nigel

"Aashi" wrote in message
...
ok im making an invoice book for school. AS project.

i hav 2 workbooks but only using one at the moment.
i have a spreadsheet with headings such as Customer name,
no, address etc and product code price quatitiy and
total. The customer details are on one userform and the
product information on the 2nd userform.

If the customer wants to order more than one product they
can click nextand a msg box appears saying "Do you want
to order another product?" "YES" or "NO". if the user
clicks "YES" the 2nd userform appears again and different
product details can be entered.
When finished the details are entered on to the top line
on a spreadsheet. Everytime u have a new customer their
details are entered at the top.

MY PROBLEM...
At the moment if a customer orders more than one product
only the last one they order is recorded.

if the customer orders more than one product I want the
customer details to be entered again onto the second line
of the spreadsheet by the click of a button.
Do u know how I can do this?

Your help will be greatly appreciated!!

userform macro button problemo
 

Thanks but where do i enter this


-----Original Message-----
Try the following, it will duplicate all of row 1

Rows("1:1").Copy
Rows("1:1").Insert shift:=xlDown
Application.CutCopyMode = False

Cheers
Nigel

"Aashi" wrote in
message
...
ok im making an invoice book for school. AS project.

i hav 2 workbooks but only using one at the moment.
i have a spreadsheet with headings such as Customer
name,
no, address etc and product code price quatitiy and
total. The customer details are on one userform and the
product information on the 2nd userform.

If the customer wants to order more than one product
they
can click nextand a msg box appears saying "Do you want
to order another product?" "YES" or "NO". if the user
clicks "YES" the 2nd userform appears again and
different
product details can be entered.
When finished the details are entered on to the top
line
on a spreadsheet. Everytime u have a new customer
their
details are entered at the top.

MY PROBLEM...
At the moment if a customer orders more than one
product
only the last one they order is recorded.

if the customer orders more than one product I want
the
customer details to be entered again onto the second
line
of the spreadsheet by the click of a button.
Do u know how I can do this?

Your help will be greatly appreciated!!



.