| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combine contents of a column
This is what I would like to do, could someone tell me if it is possible. I have 4 worksheets, in column B of 3 of those worksheets the user enters names of clients. On the 4th worksheet I would like to create a list of each unique name ( so if there were 5 instances of Bill Smith I would like it listed once) based upon the contents of column B of the first 3 worksheets.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine contents of a column
You can do this fairly easily with a pivot table, or do you want a VBA
solution? "Patrick C. Simonds" wrote: This is what I would like to do, could someone tell me if it is possible. I have 4 worksheets, in column B of 3 of those worksheets the user enters names of clients. On the 4th worksheet I would like to create a list of each unique name ( so if there were 5 instances of Bill Smith I would like it listed once) based upon the contents of column B of the first 3 worksheets.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combine contents of a column
I think that a Pivot Table might be the way to go. Having never used the Pivot Table feature I will have to do a little research on how to do that. "Barb Reinhardt" wrote in message ... You can do this fairly easily with a pivot table, or do you want a VBA solution? "Patrick C. Simonds" wrote: This is what I would like to do, could someone tell me if it is possible. I have 4 worksheets, in column B of 3 of those worksheets the user enters names of clients. On the 4th worksheet I would like to create a list of each unique name ( so if there were 5 instances of Bill Smith I would like it listed once) based upon the contents of column B of the first 3 worksheets.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine the contents of 2 cells | Excel Worksheet Functions | |||
| How do I combine the contents of two columns? | Excel Worksheet Functions | |||
| How can I sort contents of one column based on the contents ofanother column? | Excel Programming | |||
| How can I combine cell contents? | Excel Discussion (Misc queries) | |||
| I am trying to combine contents from 2 cells into 1 | Excel Worksheet Functions | |||
Linear Mode
