Formula for moving entire row once data in entered into a column

[shantelcollins]

Hi Everyone,

I have built a table to capture a list of missing reports. Each report has a case number, name, location, and date the report was generated. I also have a column listed as received. What I am trying to achieve is, once I have entered a date in the "received" column, that the row move from sheet one to sheet two automatically. Is this possible? Can you help me with the function the function used to achieve this? My excel knowledge and ability is very limited, but I am trying to learn and appreciate any help provided.

Thanks,
Shantel

[jhren]

Say your data is in Sheet 1 A1 and right, and date received is entered in H1.

On Sheet 2, any row or column, enter...
=IF(AND(Sheet1!$H1<>"",ISNUMBER(Sheet1!$H1)),Sheet1!A1,"")
...and copy right as needed.

ISNUMBER will check for H1 is a number (dates are coded serial numbers), rather than a text entry, but will not check it is a actual date). If checking for an actual date is required, let us know.

Copy down for additional consecutive rows from Sheet 1.