Forum Discussion
AAnger1750
Aug 27, 2021Copper Contributor
Moving Rows from table on One sheet to table on other Sheet based off string value
I was wondering if a macro would work when I am trying to move a whole row from a table in sheet one to a table on sheet two If column B has a value of "Finished". So the clarify I have two sheets. a...
Juliano-Petrukio
Aug 30, 2021Bronze Contributor
Please remember that this is a worksheet event driven.
So your code must refer to Worksheet_Change event.
So your code must refer to Worksheet_Change event.
AAnger1750
Aug 30, 2021Copper Contributor
Juliano-PetrukioSo I was able to get it to work but I am running into the issue of it not going to my completed sheet. It removes it from the first sheet but then disappears and does not show up where it is supposed to. I attached it if you could tell me where I messed it up.