EXCEL VBA INVOICE using userform

Question

EXCEL VBA INVOICE using userform

Anonymous

I want to create an invoice(sheet2) from the data in the

first sheet by selecting the employee, date of purchase, item and

quantity. I am working on this for a few days, Unfortunately i

couldn't find any result. Pls advice.

	sale Date	Employee <br>Name	Items	Qty	Price	<br>	---	---	---	---	---	<br>					00

26/12/2012	James	Printer	2	4,100.00
27/12/2012	James	Mouse	15	2,500.00
28/12/2012	Harris	Computer	1	12,000.00
29/12/2012	Shwetha	TV	3	52,500.00
30/12/2012	Harris	Digital camera	4	50,000.00
31/12/2012	Shwetha	Digital camera	3	35,000.00
1/01/2013	Harris	TV	2	40,000.00
1/01/2013	Shwetha	Digital camera	5	25,000.00

I want only one row to transfer to the next sheet,

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Hi, you don't need a vba, create an invoice format in sheet2, where for example in cell A11 you will enter the employee name and in B11 the date, then in C11 you want the item, in D11 the quantity and in E11 the amount, assuming that the above information is sheet1 and the used columns are A for date, then B,C,D and E in sheet2 cell C11 enter

=index(sheet1!C:C,match($A$11,sheet1!$B:$B,0),match($B$11,sheet1!$A$:A,0))

copy formula to your right

Share via

EXCEL VBA INVOICE using userform

1 answer