merging sheets

Giganews Newsgroups
Subject: merging sheets
Posted by:  Cindy Conover (
Date: Thu, 5 Mar 2009

I am not good at creating macros but here is what I would like to do:

I have 2 sheets that need to be merged together. First sheet has columns
A-G. Second sheet has columns A-C.  When merge I would like to create a
sheet 3 that will take all of sheet one and then add sheet 2 starting in
column H.  But sheet 1, column B should then match sheet 2 column A. See

Sheet 1
A        B        C        D        E        F        G

Misc    #    Misc    Misc    Misc Misc    Misc

sheet 2

A        B        C

Misc    #    Misc

sheet 3

A            B        C        D        E            F            G        H
I            J

Misc  001    Misc    Misc    Misc    misc      Misc    001    Misc

M        001A    M      M        M          M            M

            001b    M        M

Can this be done?