Create a macro that will move an entire row to a different worksheet based on cell change

[graciegables]

Hi, I've got a spreadsheet of my team's projects (Excel, Office365). One of the columns includes a drop-down list of the different statuses of a project. I'm focusing on "Completed". When someone changes the cell value to "Completed" in Column C, that will trigger the entire row to be moved to another sheet in the workbook called "Completed". I have no idea how to do the VBA for this. Can anyone help?

[BadlySpelledBuoy]

This can be done quite easily with a worksheet change event.

Could you attach a sample workbook? It will make it much easier to provide you with tailor made VBA to do the job.

BSB

[graciegables]

I'm sorry, but it's not allowing me to attach a workbook. Can you just paste the code below? Thanks!

[BadlySpelledBuoy]

Paste the below into the worksheet module. It will fire when a cell in column C that is not row 1 is changed to 'Completed' and copy columns A:Z of that row to a sheet called Completed then delete the row from the original sheet.

Please Login or Register  to view this content.

BSB