Hi,

Can anyone please help. I am very new to excel macros.
I am looking to use an excel macro to combine data in a workbook from one
column(A) on a worksheet and one column(A) from a second woksheet into a new
worksheet. The data in the columns in the worksheets could contain the same
data so I would also like to do the folllowing. I would want to sort and
compare the data and have the newly created worksheet show only one set of
data with no duplicates.

Thank You

Peter