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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Is this possible?? 3
move a row of data from one work sheet to another using a formula 1
Excel Macro to copy a row to another sheet based on date 0
use month in cell date to sum all relevant cells 2
VBA to automatically cut, paste entire row based on date input and delete row 0
Dependent drop down dynamic range formula, off sheet. 7
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
using the =page! feature to transpose a row to column 0

Back
Top