Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I combine 4 columns of data into one column? | Excel Discussion (Misc queries) | |||
how to combine number data from one column into another column | Excel Discussion (Misc queries) | |||
combine column data | Excel Discussion (Misc queries) | |||
how to combine data from Column A & B | Excel Discussion (Misc queries) | |||
How to combine data from two columns into one column? | Excel Worksheet Functions |