may take ages but i need the help right now..ne1
available?

Give us at least some outline of the problem or project
and the range of skills required.


-----Original Message-----
may take ages but i need the help right now..ne1
available?
.

hey thanks,

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!!

So you have some code that takes the information out of the userform and
places it in the worksheet? I nthat case the code would have to be modified
to find the next emply row rather than always use row 1. Maybe you should
post the key parts of your current code. From there it might be evident how
to make this modification.

--
Jim Rech
Excel MVP
"Aashi" wrote in message
...
hey thanks,

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!!