+ Reply to Thread
Results 1 to 3 of 3

MAcro to Compare two colums in different sheet and paste corresponding data.

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Question MAcro to Compare two colums in different sheet and paste corresponding data.

    Hi,

    I have two excel sheet.
    Sheet1 and Master sheet, I want a macro which can update the sheet1(whenever the data of Master sheet is changed) by comparing ColA of sheet1 with ColA of Master sheet.
    ColA can be considered as master column, And I have 20 columns in use in both sheets. It would be great if come1 can help me out here.
    And also column 2 of master is not nessary the same column in sheet1. It can be Col 3 in sheet1.

  2. #2
    Registered User
    Join Date
    03-30-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: MAcro to Compare two colums in different sheet and paste corresponding data.

    I guess no1 has an answer?

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: MAcro to Compare two colums in different sheet and paste corresponding data.

    Please attach a sample book.

+ 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. Looking to compare two different colums of data
    By pdotc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 06:27 AM
  2. Macro to Compare Columns and Copy Paste Data
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-01-2012, 01:15 PM
  3. [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
  4. Compare Data from 2 sheets and paste absent data on third sheet
    By junyi.ho in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-07-2010, 09:27 AM
  5. Compare Data from 2 sheets and paste absent data on third sheet
    By junyi.ho in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2010, 11:48 PM

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