+ Reply to Thread
Results 1 to 2 of 2

Copying all row in multiple sheets to one sheet where each sheet shares unique ID in a cel

  1. #1
    Registered User
    Join Date
    01-10-2018
    Location
    Seattle, usa
    MS-Off Ver
    2016
    Posts
    1

    Copying all row in multiple sheets to one sheet where each sheet shares unique ID in a cel

    Hi,
    Been running around internet trying to figure this out.. Im a novice in Excel so apologies if its incorrect vernacular being used.
    I have a single workbook with multiple sheets. Each sheet contains the same columns, and are all part of the master sheet, broken up for ease of editing into multiple sheets. Several columns have data inputted, and I would like to copy this data from these sheets back into the corresponding row in the master sheet. There is a column in each sheets which shares a unique identifier in a cell also found in the master sheet. Is there a way to copy several columns of data in a row, by matching the unique identifiers between the master sheet each of the other sheets?
    Many, many thanks.
    Oisin

  2. #2
    Registered User
    Join Date
    10-21-2016
    Location
    Kansas City, MO
    MS-Off Ver
    2010, 2013
    Posts
    64

    Re: Copying all row in multiple sheets to one sheet where each sheet shares unique ID in a

    Not sure if this helps or not. From what I understand, you're wanting to tell Excel to look for data on a specific sheet and put it on the Master List. It also sounds like each page has a unique identifier for each record. If this is so, you may want to use an INDEX/MATCH formula combo (see attached doc).

    If you're wanting more info on INDEX/MATCH, I've found the below link quite helpful:
    https://www.ablebits.com/office-addi...ction-vlookup/

    A somewhat easier way (for me) to visualize the formulas in combination is =INDEX([column of data with original cell]),MATCH([unique identifier in the new cell's record that is also in the original cell's record],[column on original cell's sheet containing the unique identifier], 0)). Zero will give you an exact match instead of an appoximate match, which is probably what you want.

    If I/M is what you need and you are new to this, you will probably find it quicker (especially with multiple sheets involved) to click each of your formula areas/ranges than to actually type them.
    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. Copying data from multiple sheets to one sheet
    By aparnawangu in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-22-2017, 05:53 AM
  2. Copying columns from multiple sheets into one sheet
    By priyankalaha18 in forum Excel General
    Replies: 5
    Last Post: 08-01-2017, 09:54 AM
  3. Replies: 3
    Last Post: 06-20-2014, 05:49 AM
  4. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06:29 PM
  5. Copying cells from 1 sheet to multiple sheets
    By stevenwhite1968 in forum Excel General
    Replies: 3
    Last Post: 05-10-2011, 09:49 AM
  6. Copying data from multiple sheets into one sheet
    By Todd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2005, 11:05 PM

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