I hope someone can help me with this.

On sheet 1 I have a list of prospect customers. On this sheet there is a
column called renewed.

On sheet 2 I have a list of excisting customers.

Is it possible to have the customers move automatically from sheet 1 to
sheet 2 when entering data in the renewed-column on sheet 1?

I will really appreciate it if someone can help me solve this.