I have an excel workbook that has 2 tabs with almost identical spreadsheets
(one for a log of information, one for tracking data). The entire formatting
of the spreadsheets is identical, the only difference is the data that is
inside the spreadsheet. This spreadsheet deals with a product (natural gas)
that our business group buys.

What I need is a macro that will do the following:
When we first hear about the availability of natural gas through a certain
well, we log in the name of the well (all this is irrelevant, but I'm just
trying to paint the scenario right) and all the data that pertains to it. If
our group decides to buy this gas, they will enter a date in the column
titled "Date of First Sales". At this point in time, they are manually
cutting that row, and pasting it on the 2nd tab on the next available row,
then going back and deleting the now empty row. I want to create a macro
that will automatically cut this row, paste it on the next tab in the next
available row, then delete the now empty row when the user enters a date in
"Date of First Sales". I'd need to set it up where it will send it to the
next tab when they actually leave that row, and then give them a pop up
message alerting them that their data has been moved to the next tab, just so
they dont wonder where it went.

Here's the problem though... my spreadsheet looks something like this:

WELL TYPE 1 INFORMATION
Smith #1 County ST 1/13/05
Jones #2 County ST 1/14/05

WELL TYPE 2 INFORMATION
Brown #3 County ST 1/16/05

WELL TYPE 3 INFORMATION
Haynes #6 County ST 1/17/05

This is the way both the first and second tabs are set up. The difference
is that the first tab wont have the date. When the date is entered, it needs
to move to the 2nd sheet. My problem I'm wondering about is how to make
excel know that if a date is entered under the section titled "WELL TYPE 2
INFORMATION" then it knows to move it to "WELL TYPE 2 INFORMATION" on the
other tab, and will know which available row to use. The same for WELL TYPE
1 INFORMATION and WELL TYPE 3 INFORMATION. Also, I need the row to keep the
correct formatting (color, borders, etc).

I do hope this makes sense and that someone can help me with it. Sorry for
being so wordy about trying to explain it. Any help is greatly appreciated!

Sincerly,
Stacie