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

W

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 | (e-mail address removed)
BBB | pink | 5646546 | (e-mail address removed)
FFF | white | 989865464| (e-mail address removed)
HHH | black | 546786 | (e-mail address removed)

Worksheet2
Organisation | name | Telephone | Email
AAA | purple | 8885555 | (e-mail address removed)
FFF | blue | 222111 | (e-mail address removed)
BBB | silver | 654554 | (e-mail address removed)

Here’s what the end result should look like
Worksheet3
Organisation | Name | Telephone | Email | Name2 | Telephone2 | Email2
AAA | orange | 123456 | (e-mail address removed) | purple | 8885555 |
(e-mail address removed)
BBB | pink | 5646546 | (e-mail address removed) | BBB | silver | 654554 |
(e-mail address removed)
FFF | white | 989865464| (e-mail address removed) | blue | 222111 | (e-mail address removed)
HHH | black | 546786 | (e-mail address removed) | N/A | N/A | N/A

Many thanks in advance.
 
T

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.
 
W

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.
 
W

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.
 
Top