Moving rows to another sheet automaticlly

[Alex]

I have a sheet which lists customer complaints. Each row is a different complaint and has a cell for "Closed date".
Is it possible to have the values from the entire row or a range of cells within that row move to the closed sheet when a date is entered in the closed date column?

 

[Frank Kabel]

Hi Alex

if you really want to move the data (that is on your entry sheet the
specific row is deleted) you'll need VBA. For automatic removal: Again
process the worksheet_change event. Or you can create a macro which is
invoked manually and moves all relevant rows.

But i would try to filter the data (Data - Filter) and show only the
rows without a closing date.

Frank