+ Reply to Thread
Results 1 to 2 of 2

adding data from multiple sheets based on unique ID

  1. #1
    Registered User
    Join Date
    04-18-2008
    Posts
    1

    adding data from multiple sheets based on unique ID

    Hi,

    I have three sheets. Each sheet as a column with a unique ID. All three sheets will not have the same total number of IDs.

    I need to match the ID in sheet 1 and 2, then take the data from sheet 2 and add it to the row in sheet 1. Then I need to do the same for sheet 3.

    So sheet 1 is like this:
    unique ID Data
    1 x
    2 d
    3 ff
    4 wff
    5 sdfs

    Sheet 2 is like this:
    unique ID sheet2Data
    3 aa
    1 bb
    4 cc

    The end result I want is:
    Sheet 1:

    unique ID Data sheet2Data
    1 x bb
    2 d
    3 ff aa
    4 wff cc
    5 sdfs

    I have no idea how to do this.

    thanks for any input.

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606
    Slightly unwieldy looking code but have a look at the attached. EDIT: only just registered that this is not in the VBA forum but not sure you can do this with formulae.
    Attached Files Attached Files
    Last edited by StephenR; 04-18-2008 at 03:17 PM.

+ 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