How To Loop a copy range macro until lookup cell is blank/empty

Hello, I have a 2 Macros that looks to see if a cell (i2) has info and if it does, it copies a range 057:AX57 to O2 when I click a button, which works, now what I would like to do it the macro then looks at i3, i4... and then copies the same range but next row down (O3) and loops until it hits a blank cell in "i", below is my current code, just not sure how to make it loop.

Please Login or Register  to view this content.

Any assistance would be greatly appreciated.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

I am assuming that this is the sub you wish to modify. See if this works for you

Please Login or Register  to view this content.

Suggest you upload a sample worksheet and explain your issue using the worksheet. Having difficulty visioning. Old eyes see things clearer when presented in a viewable format.

Thank Alan, no need, got it to work, appreciate your assistance. Hopefully one last question. I am able to copy just the values to clipboard, and on the Output spreadsheet 1 column of cells have a data validation drop down list setup, now if I right click and paste values, the data validation is not over ridden but if I just CTRL V, they are over ridden, any idea around this, my concern is if I am not the one doing the paste it may not be done right.

Do you have a macro associated with Ctl + P because that was a standard keyboard shortcut to Print.

No Macro, just using keyboard shortcut or right mouse click, issue is the output workbook is our data and we do not want to setup macros or vba (if possible), just the data.