Sheet names

Excel Programming >> 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.hide-link.com/ ;userid=35092
View this thread: http://www.hide-link.com/

Excel206

Excel Programming >> 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)

>
> 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?action=getinfo&userid=35092
> View this thread: http://www.excelforum.com/showthread.php?threadid=561407
>