A Pivot Table is used precisely for such computations. As a thumb rule, use Excel functions and tools where Excel can handle it efficiently. Use VBA only if Excel cannot give desired output on its own
On Jul 21, 10:19 pm, Raghavendra <raghavendra....@gmail.com> wrote: > Hi, > > Can anyone let me know VBA code for the below? > > Input Data > > Names Amount > A 100 > B 200 > C 100 > B 100 > A 100 > D 150 > > Out put data should be > > Names Amount > A 200 > B 300 > C 100 > D 150 > > Regards, > Raghavendra -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
