How do I combine information from two separate spreadsheets

[Tryn2excel]

I have a list of thousands of SKU numbers (unique number identifing an item)
with each sku having several adjacent horizontal cells with information about
that SKU. On a seperate work sheet, I have another list of the same SKU
numbers but with different information in the adjacent horizontal cells. How
do I combine into one spreadsheet so that all of the information associated
with a SKU number will be on one spreadsheet ?

 

[Don Guillett]

If the columns are IDENTICAL, just copy them. Or, You could use VLOOKUP
formulas and then copy/paste values.
Or a macro

 

[MeowSayTongue]

I have a list of thousands of SKU numbers (unique number identifing an item)
with each sku having several adjacent horizontal cells with information about
that SKU. On a seperate work sheet, I have another list of the same SKU
numbers but with different information in the adjacent horizontal cells. How
do I combine into one spreadsheet so that all of the information associated
with a SKU number will be on one spreadsheet ?

Copy one of the sheets over by right clicking on the sheet tab and
selecting (move to end) being sure to also select the "make a copy"
checkbox, and selecting the sheet you want it to get copied to (must be
an also open workbook) from the drop down list.

Then, you can insert vlookups in one sheet that calls up the data in
the other, so that you can end up with it all in one view.

If you only look at one record (SKU) at a time, you could make a sheet
in front of those and use ALL Vlookups with it (all but one) to show all
the data from those two sheets, but only for one SKU, and not the added
visual clutter of all the other records as well.

Meow