moving a row to another sheet based on cell status

i'd like the ability in a spreadsheet to have a row on one sheet move to another sheet when a value is added, has anyone done this?

With the limited information provided I will need to make a few assumptions. Alter the code to match the parameters of your sheet.

Assumptions:
1. The value is being added to column A
2. You are moving the data from a sheet named "Sheet1" to a sheet named "Sheet2"
3. You want to move the entire row to the next available row, deleting the original row on "Sheet1"

Please Login or Register  to view this content.