How to create an invoice from excel data

August 17, 2015 at 06:59:39
Specs: Linux x86_64)
Could you please assist me on this one. I have this data on one sheet that require to be auto-filled on the invoice template whenever I type in on the order number on B17. I believe this would be a macro to assist me do this.

I would like the following to appear on the invoice automatically as it appears on the raw data whenever we change the order number.

- Agent name
-Customer name/no
-Sales associate
- Invoice date
-Code
-Product Description
- Quantity
- Unit price

The file is attached on zippyshare
http://www87.zippyshare.com/v/xhsff...


See More: How to create an invoice from excel data

Report •


#1
August 24, 2015 at 08:14:33
I noticed that this question has not been answered. Are you still looking for some help or have you solved your issue?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
August 24, 2015 at 13:41:20
Yes please. Will very much appreciate... Haven't managed to crack it yet.

Report •

#3
August 24, 2015 at 17:24:29
I'm not sure I understand your goal. You say that you want to pull data from the Row Data sheet based on the Order Number, but I see more than one piece of data for each category for the same order number.

For example, on the Raw Data sheet there 29 different Agent Names listed for Order No 1, but only one spot for an Agent Name on the invoice.

If you enter a "1" in the Order No field on the Invoice sheet, which of the 29 different Agent Names do you want to appear?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
August 24, 2015 at 20:15:28
Sorry about that. Think the order numbers got mixed up at some point before I sent that out. Anyway to fix that after change in customer number/name we should have a different order number.
The order number should be unique for each customer and should pull the data that before the next customer shows up.

Report •

#5
August 25, 2015 at 04:11:27
I'm still confused. This doesn't make sense to me:

"The order number should be unique for each customer and should pull the data that before the next customer shows up."

I think it would help if you uploaded a file that has the correct order numbers in it so that we know exactly what data we are working with.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question