Dear Friend, How much time did it take to get the result?
Regards, Angelo 2010/9/29 ashish koul <koul.ash...@gmail.com> > hi > > check the attchment see it it helps you > > you can apply the filter and delte all rows with "d" and then remove the > temp column > > > > > > > On Wed, Sep 29, 2010 at 2:44 PM, Dave Bonallack <davebonall...@hotmail.com > > wrote: > >> Hi group, >> I'm hoping someone can help me with the attached workbook. >> I've written a macro that makes XL freeze. >> The need is to check the data for duplicates based on Columns B, C & D. If >> duplicates are found, their totals in Columns E & F are to be sumed, then >> the duplicate row deleted. >> I concatonate Cells B2, C2 & D2, then compare that with a concatonation of >> cells B3, C3 & D3, then B4, C4 & D4, and so on to the end of the data, >> dealing with duplicates as they come up. Then I start again with row 3, and >> so on until all the data is checked. The macro takes a long time to run, so >> I report progress in Cells G1 and H1. >> Whenever I run this macro, it never gets past about line 10 before XL >> freezes, and I have to use the Windows Task Manager to close it. >> There may be a better way of doing this, but my question is, why does it >> cause XL to freeze? It seems a simple enough piece of code. >> You will notice 5 lines of code remmed out. When active, this inserts a 1 >> second (approx) delay after each row has been checked, and the code runs >> without freezing, but of course, with 13000 rows, adds about 3.6 hours to >> the run time of the macro. >> This happens with XL2003 and XL2007, and on another computer as well. >> Anyone have any ideas? >> Regards - Dave. >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > ---------------------------------------------------------------------------------- > 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
