+ Reply to Thread
Results 1 to 3 of 3

Macro merging data help[Excel 2007]

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    19

    Macro merging data help[Excel 2007]

    Hi,
    Can anybody help me with the following problem:
    2013_07_08_09_03_29_Document1_Microsoft_Word.JPG

    So basically I would need a macro, that copies the first row of both sheets and then copies the data to the perspective columns, from both sheets only when the name(String) exactly matches.

    Keep in mind this is a multi thousand row excel sheet.

    It could be done in java programming, but can it also be done in an Excel macro, to make life easier for my coworkers?

    Any input would be greatly appreciated!

    Thank you!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,620

    Re: Macro merging data help[Excel 2007]

    Please post a sample sheet - Thx

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Macro merging data help[Excel 2007]

    Here you go:
    Example of data merging.xlsx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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