You say worksheets and then talk about two workbooks. If you copy one set
of columns and paste them next to the other set of columns, does that give
you want you want? Is it two worksheets in the same workbook? If not,
what are the sheet names in each book and do you want the combined
information in a third workbook, an additional sheet in one of the
workbooks -- try to be more specific.

If you need the data adjusted to match rows, what column has the data to be
matched? i.e. what is the unique identifier that you can match on. Will
there always be a complete set on each sheet - if not, what is the
situation? First is complete, second is partial, first and second overlap,
but each may have unique items, etc?

--
Regards,
Tom Ogilvy
"KK" wrote in message
ups.com...
Hi, Is it possible to combine two work sheets into one?

ex: I have first.xls, second.xls

firsr.xls has columns aa,bb,cc
second.xls has columns aa,bb,cc,dd

Both sheets has different data. I want to see them in a single sheet at
once side by side and should be able to compare.

appreciate your help.

Thanks