Good Morning. I'm having trouble with the above code.
I have two separate tables, but the code needs to stay generic and will be entered into each worksheet that will be using it. The first table requires the user to update certain fields and then choses the value in column M as either Yes or No. If no is chosen, nothing runs and the user continues entering. If Yes is chosen, the above code is to run. When it runs, it copies the values in that same row from columns C and D into the next available row in column P (and Q), which is in the other table. I don't have the code in here yet, but once the values are copied into column P, the code is supposed to select the next cell beside the copied values (column R), stop, and then allow the user to fill in any information in the remaining columns in that row. After that, the user will go back to the first table and continue entering/chosing M column values, and the code process starts again if relevant.
However, once the code is done initially (and it does copy everything as required), an error code comes up and the highlighted If statement is apparently the problem - it's not ending and looks like it's stuck in a loop or something - I'm guessing because now the column has more than 0 'yes' value; I'm really not sure what's going on. Can anyone help me set this code up properly?
Thanks very much for any help you can give.