Combining Data from 2 Worksheets into 1

[Purecaster]

I have one excel file with two separate worksheets with identically formatted data. The have the same data in respective columns. Part# in column 1, price in column 2, and so on...approximately 10 columns...

I basically want to combine the two worksheets into one so that the Part# from both worksheets is in one column on a 3rd worksheet. Is there any way to do this without copying and pasting the data from both worksheets into one worksheet?

Worksheet 1 (Have)
Part#
1111
2222
3333

Worksheet 2 (Have)
Part#
4444
5555
6666

Worksheet 3 (Need!)
Part#
1111
2222
3333
4444
5555
6666

 

[HowieG]

What's wrong with copying and pasting? Is this something you want to do once, or always have updated?

 

[Hasit]

Only 2 ways I know of consolidating data. Save the worksheets as workbooks and then use the:

TOOLS->MERGE WORKBOOK

and that should give you the result.

The other option is using DATA->CONSOLIDATE. This will not give you the result that you need, but I thought I would mention it!