Having trouble with macro coping data to sheet2

I have a macro for a button that isnt fully working. what it does it looks at data on sheet1 for data in columns I-L all the way down and it there is data in Column I it copies I-L row over to sheet2 and puts info in same order in sheet2 A-D and then looks at values in column D on sheet2 and whatever number is there makes that many copies (-1) under it and does this for all. So another words if column D on sheet2 says 12 it makes 12 - 1 copies and puts it right under that row so theres a total ** 12 ** those rows. which this works perfect what isnt working fully is on sheet1 theres some rows with data in Column I that it doesnt see or something so it doesnt copy that row (I-L) over and some rows it does .... cant figure it out heres my code.

It also auto widths both sheets.

Please Login or Register  to view this content.

It looks like it quits after seeing 10 blanks in Column I?

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hey Cowboy,

Your sheet is protected - can I have the password?

Nevermind: I may have found the problem:

Change:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

But the problem definitely lies within the indexing - I don't need the password, but I don't know when I'll be able to get back to it - if you single step through the code, just comment out the formatting lines at the start and you should be able to see where it's skipping input rows.

Hi Cowboy,

I did it too - here's mine:

Please Login or Register  to view this content.

And, thanks for the rep!

Oh Cowboy,

Got everything straightened out its working perfect now. I will run it through a few shipments and see if i get any new problems.

That's wonderful and the skill of Single Stepping is the programmer's secret weapon - way to go!