+ Reply to Thread
Results 1 to 2 of 2

Comparing Data From Two Sheets

  1. #1
    Registered User
    Join Date
    06-15-2018
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    2

    Unhappy Comparing Data From Two Sheets

    Hi Guys,

    I'm relatively new to Excel VBA and macros and I'm currently struggling to create a macro that would compare data from 2 sheets to find matching values and copy&paste them into the sheet named Product Info tab.

    1) In the excel sheet there are two tabs called Product Info tab, and Full Image Links with UPC tab.

    b) There are UPC numbers in both the sheets , but not in the same row. So I need a way to find the matching UPC Number from sheet "Full Image Links with UPC" and paste it to the correct row in "Product Info sheet"

    I have done the first row in "Product Info sheet". so if I do this manually its gonna be a time consuming task. Hence could you guys please help me with a VBA code or formula to do this?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,219

    Re: Comparing Data From Two Sheets

    See the yellow banner at the top of the page
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. Comparing data from 2 sheets
    By ahuang3433 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-01-2017, 06:12 PM
  2. [SOLVED] Comparing Data Across 2 sheets
    By excelmee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-04-2013, 05:55 PM
  3. [SOLVED] comparing data from different sheets
    By benjamin.grimm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-14-2013, 10:45 AM
  4. [SOLVED] Comparing data in 2 sheets
    By JakeMann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 04:13 AM
  5. Need help in comparing data in 2 sheets
    By giantsquid in forum Excel General
    Replies: 2
    Last Post: 08-26-2008, 03:30 AM
  6. Comparing two sheets of data for changes.
    By paperclip in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2006, 06:25 AM
  7. Comparing sheets data
    By Vytautas in forum Excel General
    Replies: 1
    Last Post: 02-15-2005, 06:06 AM

Tags for this Thread

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