Help with VBA/Reflection loop

Good Morning All,

I could use some help in creating a Macro that will enter data from my spreadsheet into an IBM Reflection program that I use. I first recorded the Macro in Reflection and then pasted parts into VBA. I can get it to run successfully one time, but I have not found a way to have it loop accurately through new rows of data on the spreadsheet. I want it to loop until it reaches an empty cell in column A.

I have attached the code I've written so far, and put some notes showing what information I want to loop. In addition, I need to include an If/Else statement. If certain text is found it should hit the F12 key to back out and if other text is found it should complete the desired loop process. Hopefully this is enough information. Any help you can offer will be greatly appreciated!

James

This is what I had in mind for the loop, but it's not working as it should. If it loops through five rows of data, it will get the middle 2-3 correct (sometimes). See second attachment (myattempt.txt)

Nothing on this one?