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 |

Here’s 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