I have a word document that requires a couple excel tables and in these tables there will be data entered by agents. Column D will have a drop with two options to select, either pending or resolved. I was asked to make it where if the pending option is selected the entire row is copied to the next table. There is a possibility that this may have to happen multiple times from the first table to the second.
I will need to do this for 5 tables on one document but would like to make it to where if let's say on table 3 the agent changes the drop down to resolved it stops copying the row to table 4.
I hope that makes sense and appreciate any help that could potentially be offered and I am sorry if this or something like this has been posted before.
Also, I am very basic beginner of VB scripting so if there's an easier way of doing this I'm all game for that as well. I wasn't sure if vbs would be the way or if using an if statement would work.
I will need to do this for 5 tables on one document but would like to make it to where if let's say on table 3 the agent changes the drop down to resolved it stops copying the row to table 4.
I hope that makes sense and appreciate any help that could potentially be offered and I am sorry if this or something like this has been posted before.
Also, I am very basic beginner of VB scripting so if there's an easier way of doing this I'm all game for that as well. I wasn't sure if vbs would be the way or if using an if statement would work.
