Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 4th 05, 03:41 AM
Mili
 
Posts: n/a
Default if a cell contains certain text, cut and paste to another sheet

Wanting to include this within a macro, so that if a particular cell has "N"
in the cell that the whole row will be cut and paste in to another sheet
within the workbook.

  #2   Report Post  
Old April 4th 05, 04:18 AM
Myrna Larson
 
Posts: n/a
Default

Since you're not specific WRT the cell location or the other sheet name...

If Range("A1").Value = "N" Then
Range("A1").EntireRow.Copy Worksheets("Sheet2").Range("A12")
End If


On Sun, 3 Apr 2005 19:41:01 -0700, "Mili"
wrote:

Wanting to include this within a macro, so that if a particular cell has "N"
in the cell that the whole row will be cut and paste in to another sheet
within the workbook.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017