+ Reply to Thread
Results 1 to 2 of 2

Matching names, and inserting information between worksheets

  1. #1
    Registered User
    Join Date
    06-07-2016
    Location
    Cambridge, England
    MS-Off Ver
    Latest Version
    Posts
    1

    Thumbs up Matching names, and inserting information between worksheets

    Hi everyone.

    SO I have a problem. I created a database in excel of all the previous attendees of our previous events spanning 8 different worksheets with a single overview sheet. Within these worksheets, the columns are first name, last name, email, job title, company.
    I condensed these into a single overview spreadsheet (stupidly, manually), and to compound my misery only copied across the first name and last name columns.
    I would now like to go back and grab the information associated with the first name and last name from the other worksheets, and place them in the overview sheet.

    How can I go about doing this? I know I was stupid in the first place, so no need to point that out further, would appreciate anyones help.

    Thank you!

    Joe

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,105

    Re: Matching names, and inserting information between worksheets

    This sounds like a job for VLOOKUP. It's hard to provide specifics for you without a sample workbook, but this link should get you started:

    https://support.office.com/en-us/art...8-93a18ad188a1

    If you're still having issues, try to post a small sample workbook (Use: Go Advanced > Manage Attachments) with all sensitive data altered or removed.

+ 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. Matching Information Across Worksheets
    By bbradley in forum Excel General
    Replies: 1
    Last Post: 03-03-2014, 06:10 PM
  2. Inserting comments by matching names in an array
    By ad9051 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 01:00 PM
  3. Replies: 0
    Last Post: 02-05-2013, 11:21 AM
  4. Replies: 0
    Last Post: 05-27-2012, 07:53 PM
  5. Merging two worksheets and flagging matching names
    By bmas56 in forum Excel General
    Replies: 3
    Last Post: 06-14-2011, 05:03 PM
  6. Excel 2007 : Matching across Worksheets & Inserting Data
    By Villamankh in forum Excel General
    Replies: 7
    Last Post: 12-14-2010, 11:02 AM
  7. Matching names on different worksheets with function to add abbreviations
    By ebbo in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-13-2010, 12:21 PM
  8. [SOLVED] Inserting Filtered RC cell information into other worksheets
    By Dennis in forum Excel General
    Replies: 10
    Last Post: 07-29-2005, 09:05 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