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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tryn2excel" wrote in message
...
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 ?