VBA to move rows in one sheet based on data validation

  • Hi,

    I am looking for a VBA that moves rows based on data validation selection in same Sheet

    On the same Sheet there is a paint section at the top and polish at the bottom, I need a vba to move the row to paint section if Paint is selected in data validation and then back down to polish if polish is selected.

    I have attached a spreadsheet to give an idea of what I am looking for - Data Validation in Col L


  • Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in column L.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!