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..

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..
>
>

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" <(E-Mail Removed)> wrote in message
news:13CB3CC6-4149-4850-98A3-(E-Mail Removed)...
> 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..
>>
>>