+ Reply to Thread
Results 1 to 2 of 2

Mergring two sheets information together using a search word by applying macro

  1. #1
    Registered User
    Join Date
    03-17-2015
    Location
    Toronto
    MS-Off Ver
    XP
    Posts
    3

    Mergring two sheets information together using a search word by applying macro

    Hi,

    I need help on getting a macro that can use the PEIN as the search word to display the information onto one work sheet from two different files.

    basically, i need information from nekken22 and nekken23 files searchable once i put in PEIN in cell A2; or by any design that make sense. When the PEIN matches, it will display all the records (keep in mind, the PEIN might duplicate on either file).

    Further more, if the results can use the PEIN to create a tab by itself on the worksheet, that would be fantasic.

    I think i underestimated how hard it is to write my own codes.

    If you are helping out and have questions, please ask.

    Thank you very much in advance.

    Nekken22 (see attachment for information; i am using the exact format; therefore it would be great if it can be linked up into one file)
    Attached Files Attached Files
    Last edited by nekken22; 03-20-2015 at 05:08 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Mergring two sheets information together using a search word by applying macro

    Hi Nekken,

    I don't understand what you want - can you supply a sheet that shows your desired result?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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