Combine column data into one
 

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

Combine column data into one
 

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

Combine column data into one
 

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

Combine column data into one
 

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" wrote:

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

Combine column data into one
 

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

On Sat, 16 Feb 2008 15:25:00 -0800, PAG wrote:

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" wrote:

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