Move Rows of Spreadsheet to second spreadsheet

[Closed]
Report
-
Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
-
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

1 reply

Posts
1320
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
October 8, 2021
239
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.