Hello,
I'm struggling to work out the correct VBA code to move a row in a table to the bottom open row of another sheet, deleting the row in the first sheet but still keeping the row formatting.
I have column C which is a sales stage and once it's updated to a specific stage (Won) from a validation drop down, I need that entire row to move to the Won sheet on the bottom open row while keeping the row formatting.
I'm struggling to work out the correct VBA code to move a row in a table to the bottom open row of another sheet, deleting the row in the first sheet but still keeping the row formatting.
I have column C which is a sales stage and once it's updated to a specific stage (Won) from a validation drop down, I need that entire row to move to the Won sheet on the bottom open row while keeping the row formatting.