+ Reply to Thread
Results 1 to 2 of 2

Macro to bring data to sheet from another sheet!!! based on certain criteria

  1. #1
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Macro to bring data to sheet from another sheet!!! based on certain criteria

    I have the sheet attached with a Date, Delivery Date, Plant Name, and a list of products with the other data…

    When I submit orders the data goes to a submitted order sheet as you can see…

    I want to be able to enter the Delivery date hit the insert invoice button and it will pull the orders from the submitted orders sheet that have the plant name as well as the delivery date of the one that is entered…

    So for delivery date of 1/15/15 and plant name MYRONPT1 we want to bring all the data from the submitted order sheet to the order sheet…

    Check the example file and I think you will understand better of what I am trying to do...

    THANKS IN ADVANCE FOR ALL HELP!!!

    exampleinvoice.xlsx

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Macro to bring data to sheet from another sheet!!! based on certain criteria

    Use a loop,

    Check out the attached.
    Attached Files Attached Files

+ 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. Macro Problem - trying to bring external data into one sheet
    By ids in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-15-2013, 07:15 AM
  2. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  3. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  4. [SOLVED] Macro to query data based on a criteria sheet
    By kayoke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2012, 03:10 AM
  5. Need Macro to search from mater sheet and copy in another sheet based on Criteria
    By humacdeep in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-29-2012, 01:03 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