Just use Pivot table.
Regards,
Kishan Reddy, K
On Aug 6, 4:29 pm, Sundarvelan N <nsund...@gmail.com> 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 at 4:53 PM, 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 athttp://www.excel-macros.blogspot.com
> >>> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >>> 5. Excel Tips and Tricks athttp://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
>
> --
> N.Sundarvelan
>
> BPMS.xls
> 155KViewDownload- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
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
