Sort of lost me here, but you can combine the values in two worksheets with a
simple formula. On Sheet 3 in cell A1 "=+Sheet2!A1+Sheet1!A1". If you are
then trying to get unique values, Data/Filter/Advanced Filter/Unique Values
Only.

Hope that helps.

David

"PAG" wrote:

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