Sheet names
 

Is it possible to write a macro that copies and pastes a whole row onto
a different sheet when the row contains a word in a box that
corresponds to the other sheets title?

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=561407

Sheet names
 

Is this what you mean?

If Application.CountIf(Rows(5), "text") 0 Then
Rows(5).Copy Worksheets("text").Range("A1")
End If


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"phil2006" wrote in
message ...

Is it possible to write a macro that copies and pastes a whole row onto
a different sheet when the row contains a word in a box that
corresponds to the other sheets title?

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=561407