Loop skipping random rows for no reason at all

**GeorgY** · 04-15-2009, 10:06 PM

Please take a look at the book that I have attached.

My sub is supposed to take the values from Sheet1 and paste them into 16x10 tables on Sheet2. However, for some odd reason, the loop is skipping some rows. If you take a look, there are 2184 values in Sheet1, but only 1368 end up in Sheet2...SKUs such as 518166,518167,510573,513746,513752 are just being skipped for no reason.

I would really appreciate it if someone took a look and helped me solve this.

**rylo** · 04-16-2009, 12:39 AM

Hi

Have a look at

Please Login or Register  to view this content.

What you are doing is stepping 8 for each iteration, but you are only using 5 of those 8 to get / paste data.

If you take your first row being 2, then the first loop will cover the rows 2-10. However, you are only outputting rows 2-6 with rows 7-9 not being actioned. Taking that further the some of the items you nominate are in rows 871 and 872 (518166 and 518177). Using the maths 2+108*8 you have a starting row of 866 for a block of 8 items. So rows of data would be 886-870 and if you look at your output, the associated items are output. The missing items are in the ignored rows of 871, 872 and 873.

HTH

rylo

**GeorgY** · 04-16-2009, 01:49 AM

Good catch! Thank you very much for pointing that out..sometimes I get frustrated and miss out on little things like that. All I had to do is change the Step to 5.

Thanks again!