Creating loop check cell value if so copy some cells to a external program

That can be different each time. It is in a pivot table but Grand Total is always somewhere in column J.

I tried the code but it is not recognizing the cell with Grand Total in it (maybe due to the pivot table?

Hopefully this explains better what I am trying. I want it to first look at cell J6 if not Grand total, then copy cell value J6 to external program, then copy cell K6 to external program, then copy L6 to external program. When done I want it to show pop up and ask to continue (Because I need to add some more in external program). Then I want it to go to J7 and look if not Grand Total, then copy cell value J7 to external program, then copy cell K7 to external program, then copy L7 to external program. When done I want it to show pop up and ask to continue and continue on untill Grand Total is found in a row of column J.

Added the example file. Also posted in the same file next to it the steps it should take.

Please Login or Register  to view this content.

I tried changing the code into the below, as shown in my sample file at macro. But it is not doing the steps or recognizing th

Please Login or Register  to view this content.

I def. messed up somewhere. Looks like I made a mistake somewhere either by not saving or overwritting a good script. But you loop seems to work just fine.

But the SerCursorPOS and LeftClick and Copycellcontents are all mentioned in my example file:

Please Login or Register  to view this content.

Humdingaling,
Thank you very much that you continue on helping eventhough I messed it up somewhere myself. I tried altering it to what you stated above. But the only thing that keeps happening is that I get the pop-up that Grand Total Missing. The sheet normally has some columns hidden. But to make it clear how the sheet is I expanded it all, but still couldn't get it to work.

I will try to explain what it needs to do:
Depending on what is mentioned in the row of column J:J I need to copy certain information to different places in a external non-windows program. So most logical step I think would be:
1. Check if row 6 in column J equals Grand Total
1.a. If so, then end macro
1.b. If not, then:
1.b.1. copy value in same row from column K to point X on external program
1.b.2. copy result mentioned in same row from column T to point Y on external program (Cell contains a formula)
1.b.3. copy result mentioned in same row from column V to point Z on external program (Cell contains a formula)
2. When done with the above, provide pop-up to confirm to continue. (Because we need to do some more manual handling in the external program before next value can be entered)
2.a When exit selected, end macro
2.b When continue selected:
2.b.1. Check if row 7 in column J equals Grand Total
2.b.1.a. If so, then end macro
2.b.1.b. if not, then:
2.b.1.b.1. mouse click point W on external program
2.b.1.b.2. copy value in same row from column K to point X on external program
2.b.1.b.3. copy result mentioned in same row from column T to point Y on external program (Cell contains a formula)
2.b.1.b.4. copy result mentioned in same row from column V to point Z on external program (Cell contains a formula)
3. When done with the above, provide pop-up to confirm to continue. (Because we need to do some more manual handling in the external program before next value can be entered)
3.a When exit selected, end macro
3.b When continue selected, start at 2.b.1. but do next row (8, then 9, then 10, etc.)

I know some of the cells selected are different then provided before but that was because those cells contains more information then needs to be filled in. So I created a extraction some cells further down.

I have uploaded a new and hopefully better example file.

humdingaling,

I fixed my script. When entering your loop script into my script. It works but as soon as I change the sendkey to be equals to the line it is processing it goes wrong:
Example: (Both are mentioned in coding below as well to show in complete picture)
Script works with

Please Login or Register  to view this content.

As soon as change it to

Please Login or Register  to view this content.

Here is the complete coding I have now. Which doesn't seem to work, because it does go to the first cell (Does not enter anything) but then directly shows pop-up with "Grand Total Missing"

Please Login or Register  to view this content.