Moving rows to another sheet automaticlly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top