+ Reply to Thread
Results 1 to 4 of 4

Populate my Purchase order from a list of Purchase Order numbers and their details

  1. #1
    Registered User
    Join Date
    08-11-2015
    Location
    Teesside
    MS-Off Ver
    Professional 2013
    Posts
    14

    Populate my Purchase order from a list of Purchase Order numbers and their details

    Hi
    I am new to this site and would be grateful if anyone can help with my problem :o).
    I have created a blank Purchase order on a work sheet, and I have a Purchase order list in another worksheet, that 4 people populate with the relevant details, e.g. supplier, quantity, PO number, description of goods etc.

    I want to be able to pull all these details into the Purchase Order. I was ok with vlookup using the PO number as the driving force, but it will only enter the first row of details that are relevant, but the PO number in the list has multiple lines if items. This is where I am stuck.
    Thank you in advance.
    Attached Files Attached Files
    Last edited by Carolbell44; 08-11-2015 at 06:18 AM. Reason: Add Sample spreadsheet

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,787

    Re: Populate my Purchase order from a list of Purchase Order numbers and their details

    Hi,

    See the file attached.

    I had to remove 1 merged cell to make use of the array formula-

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    08-11-2015
    Location
    Teesside
    MS-Off Ver
    Professional 2013
    Posts
    14

    Re: Populate my Purchase order from a list of Purchase Order numbers and their details

    Hi Deep Dave

    Thanks very much for your help, that's brilliant, I'm totally grateful

    Cheers

    Carol

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,787

    Re: Populate my Purchase order from a list of Purchase Order numbers and their details

    Glad to have helped..

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Thanks.
    Last edited by NeedForExcel; 08-11-2015 at 07:17 AM.

+ 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. How to connect purchase order and sell order with party ledger and daily day book
    By harisjawed86 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2014, 11:36 AM
  2. Using Price list to populate Purchase order.
    By Vaalshuffle in forum Excel General
    Replies: 4
    Last Post: 03-02-2013, 12:02 AM
  3. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM
  4. Replies: 10
    Last Post: 09-27-2012, 03:59 PM
  5. purchase order list & order number generator
    By podaf in forum Excel General
    Replies: 2
    Last Post: 06-28-2009, 06:02 PM
  6. [SOLVED] How do I list the most recent occrence of a purchase order?
    By Sharon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2006, 03:25 PM
  7. [SOLVED] purchase order counter in excel purchase order template
    By Brandy@baoco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-23-2005, 03: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