+ Reply to Thread
Results 1 to 1 of 1

Compare & update unique data between 2 files based on selcted year (through input msgbox)

  1. #1
    Forum Contributor
    Join Date
    08-12-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    133

    Compare & update unique data between 2 files based on selcted year (through input msgbox)

    Hello Guys,

    I need help in creating a Macro which will be able to perform below requirements of data comparison and update in between 2 files (sample files are attached):

    Requirements:

    1. In Sample2 file Macro would generate an Input Box to prompt user to enter the “Year” of which he wants to compare and update the data in between both files. Column B is containing the years.

    2. After providing the “Year” value the Macro should compare the data between both files for that particular year. If any unique value found in Column D of Sample2 file then data of Column A, B, C, D and G of that particular row should be get copied 3 times in Smaple1 file Column A, C, D, E and F without overwriting any previous entry.

    Please refer the attached files for having more clarity on my requirements

    Please let me know if any clarification needed.

    Thanks,
    MG
    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. Userform to Search based on Unique ID update and save data in an exel sheet
    By Rosco90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 04:50 PM
  2. Help with copying data between 2 files based on 2 unique matching conditions
    By cowboy713 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2010, 04:51 PM
  3. Update unique data based on criteria
    By starpiter in forum Excel General
    Replies: 0
    Last Post: 10-23-2009, 12:33 PM
  4. Macro to create files based on month/year
    By Jon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2005, 04:25 PM
  5. Compare 2 files and Update
    By Suncoast in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2005, 10:05 AM

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