I need to create a macro I believe--to have a row move to another sheet once a status is chosen to represent that row. For instance we have about 8 columns in each row with information on one client. The first column is named "status" denoting the status of client IE (Signed, Not Signed, In Progress) I want only the "In Progress" to remain on that first sheet. The other sheets in the document will be labeled Not Signed and Signed. When I change the status from a list in the first column of "status" from "In Progress" to "Signed" I want that entire row to MOVE to the sheet that is named "Signed" and then delete from the current sheet we were working in. Thank you in advance!
Bookmarks