I am looking for a macro or some way to make moving data automatic. I have a spreadsheet with data rows which are active (being used). Periodically, rows are complete and could be taken off the sheet so that they don't clutter the information. I would like to have a way to indicate for a particular row that it is "complete," and I'd like for that completing action to cause the row to move to another sheet for storage. I am very weak in terms of my excel skills, so I'd need pretty specific directions. The data in my spreadsheet is very basic, just descriptive.

thanks.