+ Reply to Thread
Results 1 to 4 of 4

how to use autofill from inventory workbook on invoice workbook

  1. #1
    Registered User
    Join Date
    11-19-2015
    Location
    india
    MS-Off Ver
    2013
    Posts
    10

    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.

    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?
    Attached Files Attached Files
    Last edited by ahmed1234; 11-19-2015 at 06:59 PM. Reason: added workbooks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

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

    Hi, welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-19-2015
    Location
    india
    MS-Off Ver
    2013
    Posts
    10

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

    Quote Originally Posted by FDibbins View Post
    Hi, welcome to the forum

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    attached sample workbooks

  4. #4
    Registered User
    Join Date
    11-19-2015
    Location
    india
    MS-Off Ver
    2013
    Posts
    10

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

    can someone please look into this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Autofill data from one workbook to another workbook
    By gaker10 in forum Excel General
    Replies: 3
    Last Post: 06-16-2014, 01:59 PM
  2. Copy invoice data to another workbook
    By Gstacey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2013, 05:23 AM
  3. create new workbook invoice from template
    By stuartgentle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2013, 10:33 PM
  4. inventory replenishment forcasting, new workbook
    By simpson in forum Excel General
    Replies: 4
    Last Post: 11-21-2011, 11:35 PM
  5. creating inventory workbook
    By jladdm3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-03-2008, 08:56 AM
  6. [SOLVED] Enter a customer name in the invoice workbook when the names are .
    By Muriel Ganchar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2005, 02:25 PM
  7. [SOLVED] Inventory a WorkBook
    By CLR in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1