Results 1 to 4 of 4

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

Threaded View

  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

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. 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