+ Reply to Thread
Results 1 to 8 of 8

merging info from 2 sheets within the same workbook

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    4

    merging info from 2 sheets within the same workbook

    I have information in Sheet 1 that I need to add to sheet 2. I am unable to get a formula that helps with this so I am wondering if anyone knows. I have very limited knowledge of the vlookup function.

    Issue:
    Sheet1 : Column A = Group Number; Column B = Group Name
    Sheet2: Column A = Group Number

    I need to replace the group number with the correct group name on Sheet 2. So where column A number on sheet 2 is equal to column A number on sheet 1, replace value on sheet2 column A with Name populated in column B from sheet1. So basically a mass "find and replace" option through a formula.

    Any help would be greatly appreciated!!
    Last edited by mglinski; 10-02-2014 at 11:10 AM.

  2. #2
    Registered User
    Join Date
    10-01-2014
    Location
    Arkansas
    MS-Off Ver
    2007
    Posts
    40

    Re: merging info from 2 sheets within the same workbook

    Attach your file?

  3. #3
    Registered User
    Join Date
    10-02-2014
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    4

    Re: merging info from 2 sheets within the same workbook

    Not sure how to get the file from here

  4. #4
    Registered User
    Join Date
    10-01-2014
    Location
    Arkansas
    MS-Off Ver
    2007
    Posts
    40

    Re: merging info from 2 sheets within the same workbook

    When you hit reply there is a manage attachments button that you can select to add files from your pc.

  5. #5
    Registered User
    Join Date
    10-02-2014
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    4

    Re: merging info from 2 sheets within the same workbook

    Please find attachement here (if I did it right).
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-01-2014
    Location
    Arkansas
    MS-Off Ver
    2007
    Posts
    40

    Re: merging info from 2 sheets within the same workbook

    Restriction group - tob and loc.xlsx

    Is this what you are looking for?

  7. #7
    Registered User
    Join Date
    10-02-2014
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    4

    Re: merging info from 2 sheets within the same workbook

    That is EXACTLY what I needed. Thank you so much!!!

  8. #8
    Registered User
    Join Date
    10-01-2014
    Location
    Arkansas
    MS-Off Ver
    2007
    Posts
    40

    Re: merging info from 2 sheets within the same workbook

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

+ 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. Replies: 3
    Last Post: 05-12-2014, 02:58 PM
  2. Auto generating sheets with static info and dynamic info.
    By diribarren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2014, 03:27 PM
  3. Merging: displaying which sheet data comes from when merging sheets
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-12-2012, 12:20 PM
  4. Merging different sheets of a same workbook
    By amlan009 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2012, 02:27 PM
  5. Merging all sheets present in an excel workbook into one
    By saranorton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2011, 04:03 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