Copy Paste LOOP when condition is met

Hello guys,

I have been trying to find the solution for this but I still cannot get it right, please help as my head is about to explode now, really.

In attached file and screenshot I am trying to achieve that when user clicks on invoice number and hits the LoopClick button, macro copies all the raws that are within the same customer and stops once this is done for one customer.

Lets say user clicks on invoice number 11201686 and hits the button, macro starts copying all the lines from A.M. Marketing customer and stops once all the lines are copied to sheet HideLater2 one by one.

I must have tried almost all of the loop functions but the further I got was that I can loop through until the last raw of, lets say, A.M. Marketing but looping does not copy the last line because of the offset setting that I just have not right, i dont know.

I was trying to make looping work first and then applying the copy/paste functions so you will see that it loops and does some bullshit but this is just because I could not get through the first stage - getting the loop right and the rest of the code is copied from some web.


Is there please someone who could help me? It must be something easy, some while loop or until loop and it just must stop once all the customer invoice lines are copied. I just cannot get this right.

Thank you very much!!!



Code:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. 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, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, 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

(Note: this change is not optional. As you are new, I've done it for you this time.)

Hello MarkS419

I am trying to achieve that when user clicks on invoice number and hits the LoopClick button, macro copies all the raws that are within the same customer and stops once this is done for one customer.

Have no idea what your posted code has to do with this...

You did not mention whether sheet5 has already got the Headings...Or what columns should be copied over...Or whether you want code to check if customer details are already present...

Please Login or Register  to view this content.