Macro to move entire row if cell contains a specific word and moved to sheet 2

Astarte,

Welcome to the forum. Attached is a modified version of your workbook. I had to change a few things to get it all to work:

• Moved the validation list items into a new (hidden) worksheet named 'Lists'
• Set up named ranges for each of the validation lists so that they could be used in the other two worksheets
  • Note: The named range formula isn't necessary, I put it in there so you can add/remove items to the list and it will update automatically
• Removed the conditional formatting in the 'Active' worksheet
  • When items were cut/pasted between sheets, the conditional formatting got messed up and was causing "Overlap" errors.
  • In the code, I included a VBA version of conditional formatting so that the sheet would still the desired formatting effect. This prevented the "Overlap" errors.

Here's the code that I came up with (note, this is in the ThisWorkbook event module, not a Sheet event module):

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Hi Tigeravatar,

Thank you so much it is really appreaciated.

Kind regards,

Astarte