Combine rows based off column id

[hcanning]

Hi ,
I'd like to know how to merge rows based off unique id values. Lets say I have:

ID	Name
@345	Jack
@532	Mary

<tbody>
</tbody>

and another sheet with

ID	Age
@345	32
@532	38

<tbody>
</tbody>

...
I'd like to be able to combine sheets based off id to append data

ID	Name	Age
@345	Jack	32
@352	Mary	38

<tbody>
</tbody>

...my real wold example will be comparing 500 rows or so and appending numerous columns based off the id
Thanks

 

[Fluff]

Hi & welcome to the board.
How about this

Sub GetInfo()
   Dim Ws1 As Worksheet
   Dim Ws2 As Worksheet
   Dim Cl As Range
   
   Set Ws1 = Sheets("[COLOR=#ff0000]Sheet1[/COLOR]")
   Set Ws2 = Sheets("[COLOR=#ff0000]Sheet2[/COLOR]")
   With CreateObject("scripting.dictionary")
      For Each Cl In Ws2.Range("A2", Ws2.Range("A" & Rows.Count).End(xlUp))
         If Not .exists(Cl.Value) Then .Add Cl.Value, Cl.Offset(, 1).Value
      Next Cl
      For Each Cl In Ws1.Range("A2", Ws1.Range("A" & Rows.Count).End(xlUp))
         If .exists(Cl.Value) Then Cl.Offset(, 2).Value = .Item(Cl.Value)
      Next Cl
   End With
End Sub

Change sheets names in red to suit.
This will take the data in Col B on sheet2 & add it to col C on sheet1

 

[hcanning]

Hi & welcome to the board.
How about this

Sub GetInfo()
   Dim Ws1 As Worksheet
   Dim Ws2 As Worksheet
   Dim Cl As Range
   
   Set Ws1 = Sheets("[COLOR=#ff0000]Sheet1[/COLOR]")
   Set Ws2 = Sheets("[COLOR=#ff0000]Sheet2[/COLOR]")
   With CreateObject("scripting.dictionary")
      For Each Cl In Ws2.Range("A2", Ws2.Range("A" & Rows.Count).End(xlUp))
         If Not .exists(Cl.Value) Then .Add Cl.Value, Cl.Offset(, 1).Value
      Next Cl
      For Each Cl In Ws1.Range("A2", Ws1.Range("A" & Rows.Count).End(xlUp))
         If .exists(Cl.Value) Then Cl.Offset(, 2).Value = .Item(Cl.Value)
      Next Cl
   End With
End Sub

Change sheets names in red to suit.
This will take the data in Col B on sheet2 & add it to col C on sheet1

Thanks...where do I run that. Excel novice.

 

[Fluff]

It needs to go in a Regular module. Have a look here for more details http://www.contextures.com/xlvba01.html