Combine column data into one

[PAG]

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

 

[David]

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

 

[Gord Dibben]

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

 

[PAG]

Hi

Since I am new to excel and macros I think it is hard for me to explain what
I am looking to do. I have data on two different sheets that I want to
combine into a new sheet but also not show the duplicate values.

In an excel workbook
sheet1 sheet2
A C
B A
C B
D S
E B
F G
G J
H I

 

[Gord Dibben]

You are saying you want S, I and J on a third worksheet?

See Chip Pearson's site for formulas to extract uniques from two lists.

Could be something there that will suit your needs.

http://www.cpearson.com/excel/ListFunctions.aspx


Gord