Results 1 to 11 of 11

Gather similar data in two tables

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Gather similar data in two tables

    Hello everyone

    In Sheet1 I have two tables and I need to compare these two tables in another sheet
    The logic will be as following:
    =====================
    Look at the value in column A and if found in Column F then grab the same value in both columns to the same row and so on
    As for these similar rows in both tables would be highlighted ...

    After all there will be different values in both tables (these will be put beneath each table and sorted in ascending way)

    I have put the expected output in Sheets("Output") to give you the final desired result)

    Hope it is clear
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Gather data for similar group
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-01-2016, 05:13 AM
  2. Matching Data with 3 Similar Tables(level)
    By henryyeo in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-18-2014, 05:57 AM
  3. Gather data across several similar sheets
    By fgruhlke in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2014, 10:16 PM
  4. [SOLVED] Create 10 similar tables with Excel VBA
    By kaligad in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2013, 01:54 PM
  5. Replies: 2
    Last Post: 04-29-2010, 04:27 AM
  6. Creating multiple pivot tables for similar data
    By shockeroo in forum Excel General
    Replies: 2
    Last Post: 03-31-2010, 11:05 AM
  7. Comparing 2 tables with similar content
    By Vic1978 in forum Excel General
    Replies: 5
    Last Post: 12-05-2005, 04:10 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