worked like a charm!! Thanks so much Otto!!!!

"Otto Moehrbach" wrote:

Tasha
This macro will find the first instance of "Date" in Column A and will place
the contents of Column B of the same row, into cell D2. Watch out for word
wrap. This macro has only one line besides the Sub and End Sub lines. HTH
Otto
Sub GetDate()
Range("D2").Value = Columns("A:A").Find(What:="Date",
LookAt:=xlWhole).Offset(, 1).Value
End Sub
"Tasha" wrote in message
...
I am trying to create a macro that will find the word "DATE" in column A,
then copy the date in the cell adjacent to it in the same row to cell D2.
Can someone help me with this, I've looked for roughly 2 hours on how to
accomplish and haven't gained any ground....Thanks for your help!!!