Merge contents of two worksheets

G

Grey Old Man

I am a novice writing an Excel 2002 template. I import external data from
sources A and B into sheets 1 and 2. There are no duplicate rows.

I have named dynamic ranges for them both to accomodate variable rows and
fixed columns.

How can I automatically copy the contents of sheets 1 and 2 into a
consolidated sheet 3?

Thanks in anticipation.
 
J

jeya

Go to Sheet 3 on the column type + and move the cursor to sheet 1 or 2 an
enter.

if you require the entire row pull down in the cell in sheet 3

ok
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge contents numbering 0
VBA to merge worksheets (only populated rows) 4
Trying to create a dynamic filepath within VB 3
Combining worksheets/tables into one consolidated table (or pivot 0
Combining Multilple Worksheets Into One 6
Macro to copy rows into worksheets 4
Loop required to merge worksheet data 2
Macro to combine worksheets 10

Top