Create an invoice of a customer from raw excel data as attachment shown

[hussainsaif]

Hi all,
I want to know how to create an automated invoice from raw data i already have in excel worksheet like shown below:


I want to create an invoice for print preview / print by selecting an invoice no. from a drop down list / combo, and the rest of the fields should be automatically filled using above data.

Your help in this regard is very much awaited.


[TABLE="width: 1351"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Invoice No.
[/TD]
[TD]Name and Address of the Party
[/TD]
[TD]Goods Sold
[/TD]
[TD]Quantity
[/TD]
[TD]Price (P.U.)
[/TD]
[TD]GROSS AMOUNT
[/TD]
[TD]DISCOUNT %
[/TD]
[TD]NET AMOUNT
[/TD]
[/TR]
[TR]
[TD]29-Oct-18
[/TD]
[TD]1108-18-19
[/TD]
[TD]NOOR AUTOS (KOHAT)
[/TD]
[TD]QA-563
[/TD]
[TD]8
[/TD]
[TD]575
[/TD]
[TD]4600
[/TD]
[TD]15
[/TD]
[TD]3,910.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1109-18-19
[/TD]
[TD]CASH SALE (LHR)
[/TD]
[TD]QC-291
[/TD]
[TD]10
[/TD]
[TD]275
[/TD]
[TD]2750
[/TD]
[TD]0
[/TD]
[TD]2,750.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1110-18-19
[/TD]
[TD]HYUNDAI CENTRE (GUJRAT)
[/TD]
[TD]QA-H04
[/TD]
[TD]36
[/TD]
[TD]500
[/TD]
[TD]18000
[/TD]
[TD]10
[/TD]
[TD]16,200.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1110-18-19
[/TD]
[TD]HYUNDAI CENTRE (GUJRAT)
[/TD]
[TD]QC-3347
[/TD]
[TD]50
[/TD]
[TD]340
[/TD]
[TD]17000
[/TD]
[TD]10
[/TD]
[TD]15,300.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1111-18-19
[/TD]
[TD]HAJI LAL ZAREEN AUTOS
[/TD]
[TD]QA-736A
[/TD]
[TD]2
[/TD]
[TD]1200
[/TD]
[TD]2400
[/TD]
[TD]10
[/TD]
[TD]2,160.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1111-18-19
[/TD]
[TD]HAJI LAL ZAREEN AUTOS
[/TD]
[TD]QA-1862/3
[/TD]
[TD]2
[/TD]
[TD]2600
[/TD]
[TD]5200
[/TD]
[TD]10
[/TD]
[TD]4,680.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1111-18-19
[/TD]
[TD]HAJI LAL ZAREEN AUTOS
[/TD]
[TD]QO-3511
[/TD]
[TD]6
[/TD]
[TD]225
[/TD]
[TD]1350
[/TD]
[TD]10
[/TD]
[TD]1,215.00
[/TD]
[/TR]
[TR]
[TD]31-Oct-18
[/TD]
[TD]1111-18-19
[/TD]
[TD]HAJI LAL ZAREEN AUTOS
[/TD]
[TD]QF-001
[/TD]
[TD]4
[/TD]
[TD]300
[/TD]
[TD]1200
[/TD]
[TD]10
[/TD]
[TD]1,080.00
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Macropod]

You could use a mailmerge for this. For the basics, see: https://support.office.com/en-us/ar...eadsheet-858C7D7F-5CC0-4BA1-9A7B-0A948FA3D7D3

 

[hussainsaif]

No sir, i want it in ms excel, either in new worksheet or same but i have to design a report like form for this, kindly help me.