Posting again - Deleting rows in excel and moving to new tabs

[amitvnarendra]

Hello,

Under the Plan tab, I want delete the row from the excel when I select complete in the column. The row then should move to the new tab Closed Item.
However, I want to maintain the format. So lets say an item is Complete under second section Risk Governance & Reporting then that item be removed from the item list and move to the Closed Item tab under heading Risk Governance & Reporting section.

I have attached two pictures show the data format. Picture one is of Plan tab and Picture two is the Closed Item tab.

Could you please help me solve this.

 

[Joe4]

Duplicate to: Deleting rows in excel and moving to new tabs

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.