VBA / Macro for creating new worksheets and new columns from existing worksheets

[webby2006]

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 | [email protected]
BBB | pink | 5646546 | [email protected]
FFF | white | 989865464| [email protected]
HHH | black | 546786 | [email protected]

Worksheet2
Organisation | name | Telephone | Email
AAA | purple | 8885555 | [email protected]
FFF | blue | 222111 | [email protected]
BBB | silver | 654554 | [email protected]

Here’s what the end result should look like
Worksheet3
Organisation | Name | Telephone | Email | Name2 | Telephone2 | Email2
AAA | orange | 123456 | [email protected] | purple | 8885555 | [email protected]
BBB | pink | 5646546 | [email protected] | BBB | silver | 654554 | [email protected]
FFF | white | 989865464| [email protected] | blue | 222111 | [email protected]
HHH | black | 546786 | [email protected] | N/A | N/A | N/A

Many thanks in advance.

[Tom Ogilvy]

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 | [email protected]
> BBB | pink | 5646546 | [email protected]
> FFF | white | 989865464| [email protected]
> HHH | black | 546786 | [email protected]
>
> Worksheet2
> Organisation | name | Telephone | Email
> AAA | purple | 8885555 | [email protected]
> FFF | blue | 222111 | [email protected]
> BBB | silver | 654554 | [email protected]
>
> Here’s what the end result should look like
> Worksheet3
> Organisation | Name | Telephone | Email | Name2 | Telephone2 | Email2
> AAA | orange | 123456 | [email protected] | purple | 8885555 |
> [email protected]
> BBB | pink | 5646546 | [email protected] | BBB | silver | 654554 |
> [email protected]
> FFF | white | 989865464| [email protected] | blue | 222111 | [email protected]
> HHH | black | 546786 | [email protected] | 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
>
>

[webby2006]

Dear Tom,

Thank you for sharing your knowledge. I am very happy indeed and it worked a treat. Never seen/used this function before and today I have gained great knowledge, the wizard looks complicated but once I saw the formular I was able to produce others bypassing the wizard altogether.

Thanks once again.

[webby2006]

Dear Tom,

Thank you for sharing your knowledge. I am very happy indeed and it worked a treat. Never seen/used this function before and today I have gained great knowledge, the wizard looks complicated but once I saw the formular I was able to produce others bypassing the wizard altogether.

Thanks once again.