+ Reply to Thread
Results 1 to 1 of 1

formula or macro to compare 2 data sheets and to list up all subject to criteria order sh

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,079

    formula or macro to compare 2 data sheets and to list up all subject to criteria order sh

    Hi

    Hi


    I have a workbook with 3 sheets .


    1 master
    2 order
    3 Summary

    need from order sheet to match data from master and to put it on the summary sheet .

    Note that master sheet may same items that can be find in triplicates or much more but have different po .

    So summary sheet should list all items that are on master based on order .

    the key field is ITEMNO for both master and order sheet

    Annexed sample,take note the master can go up 30000 rows of data

    thanks if any can help me
    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. Remove subject data based on criteria
    By zizou0178 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2014, 08:35 AM
  2. Formula to compare two sets of similar data on two sheets
    By twoheadedgames in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-23-2013, 04:18 AM
  3. Replies: 0
    Last Post: 02-28-2013, 07:28 AM
  4. Replies: 0
    Last Post: 01-15-2013, 11:30 AM
  5. [SOLVED] Macro to compare data between sheets and copy/paste
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-24-2012, 05:46 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