copy the "master" list. Then use the vlookup worksheet formula to pull over
the data from the other list.

See Excel Help for Vlookup. No VBA is required.

If you want to use VBA, then incorporate the vlookup function in your code
to do all the hard work.

--
Regards,
Tom Ogilvy


"webby2006" wrote:


Please excuse my ignorance after searching for hours I have yet to find
an answer to my problem. I am trying to create a new worksheet from two
existing worksheets of similar data.

Worksheet1
Organisation | Name | Telephone | Email
AAA | orange | 123456 |
BBB | pink | 5646546 |
FFF | white | 989865464|
HHH | black | 546786 |

Worksheet2
Organisation | name | Telephone | Email
AAA | purple | 8885555 |
FFF | blue | 222111 |
BBB | silver | 654554 |

Heres what the end result should look like
Worksheet3
Organisation | Name | Telephone | Email | Name2 | Telephone2 | Email2
AAA | orange | 123456 | | purple | 8885555 |

BBB | pink | 5646546 | | BBB | silver | 654554 |

FFF | white | 989865464| | blue | 222111 |
HHH | black | 546786 | | N/A | N/A | N/A

Many thanks in advance.


--
webby2006
------------------------------------------------------------------------
webby2006's Profile: http://www.excelforum.com/member.php...o&userid=36744
View this thread: http://www.excelforum.com/showthread...hreadid=564666