merging sheets

[Cindy Conover]

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

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
Misc

M 001A M M M M M


001b M M

Can this be done?

TIA
Cindy

 

[AltaEgo]

The use of 'Misc' for example data and the lack of any reference to 001 in
your Sheet1, Sheet2, and Sheet3 data makes your question difficult to
interpret.

I understand that you need column data to appear in a different location.
However, Is your data aligned by row or is it likely to appear at random by
row (e.g. same key value in on column has data appearing different rows in
each sheet). Depending on the answer, you may need to use lookup formula.
See how to use VLookup on the Contextures site:
http://www.contextures.com/xlFunctions02.html

If your key data are aligned by row, you can use a simple formula, for
example the following:

=Sheet1!C1

will show the value that appears in Sheet1, cell reference C1 no matter
which cell or sheet you place it within your workbook.