combine two workbooks in excel

[avatar8481]

Hello, I have two different workbooks which list two seperate sets of data pertaining to the items, parcels of land, and I'd like to combine the two workbooks into one, with all the data from both. Each parcel has an identifier in the workbooks that's consistent across the two, so there is a dimension of similarity between them, is there a way to automatically combine these two workbooks or will I have to do it by hand? Thanks in advance.

 

[Chopstik]

Should simply be able to copy the worksheet from the second (by right-clicking on the tab at the bottom of the sheet) sheet and then clicking on Move or Copy. This will prompt with another box and then you can copy over to the first workbook. You will need to have the first workbook open when you do this. HTH. Give me liberty, or give me pizza...