MOVE all values in a row to next sheet when date is entered in column

Hi Everyone

I know it can be done but I don't know how to write the macro.

In the attached file, first tab - Current Hotel Info - I would like to move an entire line if a date is entered into column O

I would like the row to move to the next sheet, titled Shipped Hotel Info and not remain on the first tab.

Thank you for your help!

Irene

Hotel Info Tracking sample.xlsx

Ok

This might be slightly better that sktneer's code, in your environment.

Firstly no messagebox to slow you down
Secondly you don't need to entire a date into a cell to trigger the event.

Simply type ed for enter date.

This will enter the date and then move the row.

Please Login or Register  to view this content.

Right Click on the sheet name at the bottom of excel and select view code

Paste the code above there

Close the macro window

Save you file

Type ed in column O.

Please Login or Register  to view this content.

It worked, and then it stopped! I am attaching the whole document (with identifying info removed) to see if maybe the conditional formatting I added after may have changed something?

Hotel Info Tracking sample.xlsx.xlsm

In the third line

You changed false to true.