| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste row based on cell content
I'm having trouble writing a macro that will copy a row of a table and paste
it into another sheet based on if the contents of a single cell in the row contain a certain word. Thanks, BDan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy and paste row based on cell content
Sub CopyRow()
Dim SingleCell as Range Set SingleCell = Range("A1") If InStr(1,SingleCell.Value,"certain word") 0 Then SingleCell.EntireRow.Copy Sheets(2).Activate Cells(1,1).PasteSpecial xlPasteAll End Sub HTH Die_Another_Day BDan wrote: I'm having trouble writing a macro that will copy a row of a table and paste it into another sheet based on if the contents of a single cell in the row contain a certain word. Thanks, BDan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy row based on cell content | New Users to Excel | |||
| based on Cell/Column content ,cut one sheet's values and paste it in other sheet? | Excel Programming | |||
| based on Cell/Column content ,cut one sheet's values and paste it in other sheet? | Excel Programming | |||
| How do I copy a formula/paste w/o losing the cell content? | Excel Discussion (Misc queries) | |||
| Copy/Paste based on cell content. | Excel Programming | |||
Linear Mode
