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
<tbody>
</tbody>
Inventory Format
<tbody>
</tbody>
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?
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
# | Product | Packing | Manufacturer | Quantity | Price |
1 | |||||
2 |
<tbody>
</tbody>
Inventory Format
Product | Packing | Manufacturer | Cost Price | Sell Price | TAX | Vendor | Type |
shampoo | 100gm | loreal | 10 | 14 | 5 | abc | |
soap | 75gm | sunsilk | 8 | 11 | 5 | abc |
<tbody>
</tbody>
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?