Finding a (Changing)value and cutting all data to a new sheet
Posted by George on December 18, 2000 8:03 AM
I am trying to find a value in a column. when that value is found, I need to select all rows with this value, select them, cut and paste all rows to a new page. I am having a problem with selecting all rows with this value. I can find it with the following protion of my macro:
Selection.Find(What:="2", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
As of now all rows have a value of 1 or 2.
I can cut and paste to a new sheet, but now it is coded into the formula. ( as :
Is there a way to have this active cell constantly changing and not hard coded into the formula?