David

but you can combine the values in two worksheets with a
simple formula

Not with the formula you posted.

Try =Sheet2!A1 & Sheet1!A1 to combine

Unless you mean to sum the two, in which case your original is OK.

The "+" in "=+" is not necessary.


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 15:05:00 -0800, David
wrote:

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