Moving data from one sheet when criteria met to another sheet

Copper Contributor

for example

if I have 7 columns of data required for every entry I make.

when I have received all my data I enter completed in the last Colum.

 

However I want to remove all the completed data to another sheet leaving my current sheet with all the uncompleted data only

 

can this be done?

 

0 Replies