Transfer data between worksheets

[Guest]

I have one worksheet that has all of my information, and I would like to set
it up that if a certain cell changes, that row gets moved to another sheet.
Is this poosible? If so how would I go about doing it?

 

[Guest]

************************
if a certain cell changes, that row gets moved to another sheet.
**************************
First I assume you want to Copy and Paste the row data rather than "Move"
the row. If you really want to "Move" the row you will still copy/paste then
delete the original row.

So, Rt-click the sheet Tab (at the bottom)>click ViewCode
Copy and paste the following code:
Private Sub Worksheet_Change(ByVal Target as Range)
If Target.Count>1 Then Exit Sub
If Not Intersect(Target, Range("Your Certain Cell or range")) Is
Nothing Then 'Insert your range
Target.EntireRow.Copy _
Destination:=Sheets("EnterYourSheetName").Range("A5") 'Change
the 5 to whatever row you like
End If
End Sub