Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.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.excelforum.com/member.php...o&userid=35092 View this thread: http://www.excelforum.com/showthread...hreadid=561407 |
#2
Posted to microsoft.public.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) "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Referencing - autofilling sheet names | Excel Worksheet Functions | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Using Sheet names & Workbook names in VBA coding | Excel Programming | |||
I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming |