Results 1 to 4 of 4

Thread: how to use autofill from inventory workbook on invoice workbook
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how to use autofill from inventory workbook on invoice workbook

    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
    # Product Packing Manufacturer Quantity Price
    1
    2

    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

    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?

  2. #2
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to use autofill from inventory workbook on invoice workbook

    anyone?

  3. #3
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to use autofill from inventory workbook on invoice workbook

    bump

  4. #4
    Board Regular
    Join Date
    Aug 2015
    Posts
    59
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to use autofill from inventory workbook on invoice workbook

    last bump

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •