Hi Sundarvelan,
I don't know how to do this without VBA because of the duplicates, sorry.
Regards - Dave.
Date: Mon, 9 Aug 2010 22:58:21 +0530
Subject: Re: $$Excel-Macros$$ Excel VBA : Unique Values
From: nsund...@gmail.com
To: excel-macros@googlegroups.com
Thank you So much!!!
Sundarvelan,
Uploaded a file in http://groups.google.com/group/excel-macros/files
with Team+List_Home.xls name.
This will add new name automatically when you add name in your data.
Does any one help me? I am not getting option to upload file in post?
How & From where I can upload in post directly?
Just use Pivot table.
Regards,
Kishan Reddy, K
On Aug 6, 4:29 pm, Sundarvelan N wrote:
> Hi Abhishek,
>
> Could you help in one more task also.
>
> That is under each Team leader i need to have corresponding agents name.
>
> Please help.
>
> Thanks
> Sundarvelan
>
>
>
>
>
> On Fri, Aug 6, 2010
Hi Abhishek,
Please help to proceed with ur idea.
Thanks,
Sundarvelan
On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain wrote:
> Dear Sundar,
>
> There are two things -
>
> First -
>
> If you want to put all unique values (the existing ones and the newly
> added) in those 3 columns and are ready to
Sundar,
I don't understand "what is my idea". I told you two different options.
Does the first option not help you ? Have you tried adding those 2 lines in
your code ? I mean that's what you asked at the first place. The code was
giving an error upon running second time because the cells were not
Dear Sundar,
There are two things -
First -
If you want to put all unique values (the existing ones and the newly added)
in those 3 columns and are ready to hit Update button every time then add
the following two lines in the beginning of your code -
*Range("N5:P65000").Select
Selection.ClearCo
