I have a data set of 500 rows with 11 columns of data but more rows will conatantly be added. I need a MACRO to look at the value in Column J and if that value is "Active" then I need to cut and paste that row into another sheet called "Active" in the first empty row. This MACRO will need be assigned to a button and run whenever the button is pressed.