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.
Inventory Format
b67a472c160ce23dcbe2f34d95233f47.png
Invoice Format
dab06acc2258b66ac61ebdae9d85f151.png
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?
Bookmarks