+ Reply to Thread
Results 1 to 6 of 6

Creating an order form that populates automatically from inventory sheet

  1. #1
    Registered User
    Join Date
    01-30-2018
    Location
    New Jersey
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    3

    Question Creating an order form that populates automatically from inventory sheet

    Hey guys, hoping I can get some guidance on making a smarter order form for my admin folks.

    I created an inventory sheet for everything we have, and I'd like to make another sheet that, when a column is filled with the products' Inventory ID numbers, the next column automatically populates with the price of the product that's listed on the inventory sheet. Additionally, I'd like a column that, when a "Quantity" column is filled, is automatically populated with the price of the total quantity ordered.

    Thanks for taking the time to read this. I'd be happy to clarify anything.

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: Creating an order form that populates automatically from inventory sheet

    Please provide the sample excel sheet, to assist you in a better way.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    01-30-2018
    Location
    New Jersey
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    3

    Post Re: Creating an order form that populates automatically from inventory sheet

    Sure. I used just a stock template as a sample, didn't populate it with anything new, and created a new sheet with the four columns i described above (inventory ID, price, quantity needed, total price). It ain't pretty, but it'll do.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Creating an order form that populates automatically from inventory sheet

    Create list of inventory and namas range called "Inventory"

    in B2

    Data Validation

    Allow: List

    Source: =Inventory

    in C2

    =VLOOKUP($B2,InventoryList[[Inventory ID]:[Quantity in Reorder]],4,0)

    in E2

    =$C2*$D2
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-30-2018
    Location
    New Jersey
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    3

    Re: Creating an order form that populates automatically from inventory sheet

    Thanks for your input.

    What I was trying to do is have a formula I can apply to the entire C column on that "Ordering" sheet where, when I type an inventory ID number in colum B, column C would automatically populate with the appropriate price for that product. The "quantity" and "total price" columns I have a handle on. It's really being able to populate that C column with the price that corresponds to the same inventory number from the previous page. Is there any function I can use that can find the identical input of the product ID on the inventory page and populate the price from that same row?

    Please let me know if you need any more clarification.

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Creating an order form that populates automatically from inventory sheet

    That is what the solution does !?

    Change B2 to

    =IF(B2="","",VLOOKUP($B2,InventoryList[[Inventory ID]:[Quantity in Reorder]],4,0))

    and copy down as far required

    Select in B and you get price in C

+ 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. Replies: 3
    Last Post: 04-10-2015, 11:54 AM
  2. [SOLVED] Order Form to Summarise Order on another sheet with a Submit Order Button
    By KazzICC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2014, 03:25 AM
  3. form populates the wrong data sheet
    By zak.horrocks in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-15-2014, 10:25 AM
  4. [SOLVED] Drop down menu for an inventory order form
    By deafdef in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2014, 02:46 AM
  5. Create a User form that populates another sheet in excel with data from Access.
    By laras08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2013, 04:03 PM
  6. Need help creating form that populates with data in row
    By benji912 in forum Excel General
    Replies: 12
    Last Post: 03-10-2013, 10:36 PM
  7. Help with order form that will update an inventory
    By JDobbsy1987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2012, 06:57 PM

Tags for this Thread

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