VBA code to add cells to a row based on values in current cells in the row

[david_q]

I have an excel sheet e.g.

name age
jim 58
mary 25
john 23
tan 45
lee 22
jane 35


and another sheet with

name gender
jim m
jane f
lee m
tan m


I would like to combine them based on name to get


name age gender
jim 58 m
mary 25
john 23
tan 45 m
lee 22 m
jane 35 f


So the values which are missing in the second table should be left blank in the main table but if a value exists it should be added to the row. The values in the second table are not in the same order as in the first table.

Thanks!

[StephenR]

I suggest you investigate the VLOOKUP formula. If you get stuck post a workbook.