any alternative method for looping?

**dan2010** · 09-16-2010, 11:57 AM

Hi all, this is the code i have currently. it is working but takes too long to finish its task.

Please Login or Register  to view this content.

i tried this code with 500 entries and it took 1-2min to finish comparing. my real work sample has more than 60k entries, it will take ages to finish comparing. so i am thinking whether is there any alternative to make it run faster?

thanks

**romperstomper** · 09-16-2010, 12:14 PM

Instead of the outer loop, use Find to locate the data you are interested in in column A, then check column C and loop if required, or use an autofilter.

**JBeaucaire** · 09-16-2010, 12:14 PM

Can you explain verbally what is going on?

**dan2010** · 09-17-2010, 03:43 AM

sheet "raw_data" is the master sheet with all data. i had a macro to copy some of the data from "raw data" to "manual selection" while "hidden sheet" will include the remaining data. so this macro will check to make sure that data that will be copied from "raw data" to "hidden sheet" is not in "manual selection".

**snb** · 09-17-2010, 03:51 AM

Please post a sample of those 2 sheets. There are many ways and methods to compare data. The most appropriate depends also on the structure of those sheets.

**dan2010** · 09-17-2010, 04:13 AM

there, i have upload my sample file. the looping macro is at sheet manual selection,"add road". please note that the real file will consist at least 60k entries or more. thanks