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 empty
where it was trying to put the results. Now after adding those lines, the
code is working fine. Was this not required ?
Please help me understand what exactly do you require.
Hope you don't mind my questions.
Cheers!
AJ
On 8/6/10, Sundarvelan N <nsund...@gmail.com> wrote:
>
> Hi Abhishek,
>
> Please help to proceed with ur idea.
>
> Thanks,
> Sundarvelan
>
>
> On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain <abhishek....@gmail.com>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 hit Update button every time then
>> add the following two lines in the beginning of your code -
>>
>> *Range("N5:P65000").Select
>> Selection.ClearContents
>> *
>> This will clear the existing records in those 3 columns and allow your
>> code to put new unique values. Remember - *You have to press the Update
>> button each time* you wish to reflect the most updated data.
>>
>>
>> Second -
>>
>> If you want to put existing unique values in those 3 columns only once and
>> then get the new ones updated automatically, i.e., *without pressing the
>> Update button* then, this is something entirely different. You can do
>> this too but you have to use an add-in for that. If this is what you want,
>> let me know, I'll guide you through the process.
>>
>>
>>
>> Cheers!
>>
>> AJ
>>
>>
>> On 8/6/10, Sundarvelan N <nsund...@gmail.com> wrote:
>>>
>>> Hello Friends,
>>>
>>>
>>> Please help me to finish my assignment.
>>>
>>>
>>> I have attached a excel file, in that i need unique team leaders name
>>> from E column and updated in the N column, Like wise Managers, Departments.
>>>
>>>
>>> I Need VBA Code that automatically updates if any new entries in the E
>>> column it must update in the N column.
>>>
>>>
>>> I have already done / tried one work it runs OK for first time. If i
>>> click for second time it gives error message. It is a mix of recorded code
>>> plus manual changes.
>>>
>>>
>>> Please help me
>>>
>>> Thanks,
>>> N.Sundarvelan
>>>
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>>
>>
>>
>
>
>
> --
> N.Sundarvelan
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
