Excel 2007 : Looking for way to automatically move finished data

**Lucylou88** · 03-28-2010, 11:59 AM

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.

**JBeaucaire** · 03-28-2010, 12:42 PM

A macro is the easiest way to do it, at least for me.

1) Pick a new column, let's say "M" and we'll make that the "status" column.

2) Create a data validation list active in that column with your status options. You could just type the statuses in, but it's more prone to typos.

3) Then setup an archive sheet. Let's called it Completed.

4) Then on your activity sheet, right-click on the sheet tab and select VIEW CODE

5) Paste in this sheet-event macro which will watch column "M" for you to enter Complete in any cell in that column

Please Login or Register  to view this content.

6) Close the editor and save your workbook as macro-enabled

That should do it. Anytime you put "complete" or "completed" or any word starting with "compl" in column M, it will move to the Completed worksheet.