Move Rows of Spreadsheet to second spreadsheetClosed

Question

Good Morning-

I am keeping a spreadsheet of my projects.  I want to keep the information for tracking and statistics later.  Is there a way to move the row and all the data to another row once the value is complete.

Example:
Sheet one currently has a summary of all the projects I have done.  I currently highlight the ones that are not complete.  I want to move all rows that have "COMPLETE" as the status to sheet two.

Thanks,
Scott

vcoolio · Answer

Hello Scott,

Have a look at this very recent thread:-

https://ccm.net/forum/affich-910431-transfer-between-excel-worksheets

I think its near identical to your query.

You should only need to change the criteria from 0# to "COMPLETE" and possibly the column that is being filtered (Column B in the above thread). Make sure that "COMPLETE" IS wrapped in quotation marks.

There is a link to a test work book in that thread so have a play with it then come back here and let us know your thoughts.

I hope that this helps.

Cheerio,
vcoolio.

Move Rows of Spreadsheet to second spreadsheet

1 response

Similar discussions

Subscribe To Our Newsletter!