I have a sheet (See attached) in which I want the rows to be moved to another sheet when a value is selected for column E. When the value "complete" is selected on sheet Chambers, McDonald, Teabo, or Williams that entire row would be moved to Sheet1.
Any help would be appreciated.
Bookmarks