Simplify Loops in Code

[MusicMan]

Hi,

Below you'll find a small portion some Ron Debruin code that I use to append raw data.. I would like for this to be simplified if possible. The total code runs in about 4 to 5 minutes to complete. About 90 percent of the code looks like this:

Please Login or Register  to view this content.

Any help that you could provide would be greatly appreciated.

[6StringJazzer]

How many rows of data do you have?

[MusicMan]

Thanks for replying. It's usually anywhere from 30,000 to 100,000 depending the number of work items.

[6StringJazzer]

I don't see anything intrinsically inefficient in the code, but there may be a more efficient way to achieve your result. Can you describe what you need this code to do with your data?

[MusicMan]

The code works just fine I was trying to make it more efficient if at all possible to reduce the time it takes. Thank you for looking into it.

[MusicMan]

I was wondering if maybe some non-looping method would be more efficient?

[6StringJazzer]

The code works just fine I was trying to make it more efficient if at all possible to reduce the time it takes. Thank you for looking into it.

One way to make it more efficient is to use a completely different method, but to do that I need to understand what you want it to do.

[MusicMan]

I group the data starting with 1.2. together to place in another column for analysis. Other pieces of information is also pulled from the raw data for other purposes. It all is combined in a report that is updated daily.