how to use autofill from inventory workbook on invoice workbook

[fowzan]

hi,
i have 2 different workbooks. 1 for inventory and other for creating invoices.
i want to create an autofill/dropdown in the invoice workbook.

Invoice Format
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]#[/TD]
[TD]Product[/TD]
[TD]Packing[/TD]
[TD]Manufacturer[/TD]
[TD]Quantity[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Inventory Format
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Product[/TD]
[TD]Packing[/TD]
[TD]Manufacturer[/TD]
[TD]Cost Price[/TD]
[TD]Sell Price[/TD]
[TD]TAX[/TD]
[TD]Vendor[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]shampoo[/TD]
[TD]100gm[/TD]
[TD]loreal[/TD]
[TD]10[/TD]
[TD]14[/TD]
[TD]5[/TD]
[TD]abc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]soap[/TD]
[TD]75gm[/TD]
[TD]sunsilk[/TD]
[TD]8[/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]abc[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i have 28k items in the inventory. i want to link the invoice and inventory in such a way that when i start entering product name in invoice i get a list of the items with the current characters entered, and after selecting the item the other columns like packing, manufacturer and price fill in automatically.
is this doable?

 

[fowzan]

anyone?

 

[fowzan]

bump

 

[fowzan]

last bump