Automatically deleting and moving a row to new sheet depending on cell value

Hi there!

My first post! Seriously hoping someone can help me out here, I've got an accuracy tracker that I'd like to slicken up to help out at work.

At the moment I have a managed to set up a table with a form to input values in relation to the client record details and type of accuracy check, but once our accuracy check has been completed, I would like to be able to collate them onto a second worksheet.

I have a column 'L' called 'Done?' which when updated to 'Yes', I would like the sheet to automatically delete the row and copy it to the second sheet. My first sheet is called 'Outstanding Checks' and my second sheet is called 'Completed Checks'.

I have searched HIGH AND LOW for hours on the internet for a code/formula that can help but the truth is I'm still a novice at code and when trying to alter the codes I've come across to suit my needs, nothing happens on the sheet.

If anyone could help me out with instructions on how to set this up, I'd be grateful. Using the auto-filter is not an option as many who use the sheet have complained they don't know how to use it and would prefer to see the sheet do this automatically.

Any advice? Thanks in advance!!

Hey,

Thanks so much for getting back to me so quick! I'm sorry to be so thick, there was no 'View Code' on the right click menu so I've selected 'View Code' under the developer tab, and copy and pasted the code there, but nothing happened?

Thanks again in advance.

Hi,

I've managed to find the 'View Code' and copied and pasted the code you kindly sent me. I've put 'Yes' in column L but nothing happened, is there something I need to do to get run the code or should it do it automatically? I'm so sorry to be a pain!

Thanks!

Hey, sorry it's taken me so long to get back to you, the formula works great! Thank you so much.