Moving Row of data to other sheets based on drop down selection

    Good morning!


    Before I decided to post this question I did some research on the forum to see if this question has been asked before. I did find a post resembling what I needed but it was not "noob friendly" enough for me to fully grasp what needed to be done to make the code work.


    Basically, I have a workbook with 4 sheets. The sheets are labeled as Active, Inactive, Refusal, and Hospice. The main sheet that we work on is the 'Active' sheet. Within this sheet, starting on cell J4 and down, I have a drop down menu where you can choose the the status (labeled the same as the sheet names). What I am looking to do is to have specific information from that row to move to the respectively named sheet whilst simultaneously deleting that entire row from the "Active" sheet.



    Any and all help would be greatly appreciated!! Thank you very much in advance for any help!

    Could you attach a workbook with your lay-out.
    What kind of drop-downs? Forms controls or Validtaion or something else.
    Where in the destination sheet do you want the row of data to be moved?
    When you change one of the dropdowns in column A, do you want the data removed from the previously selected sheet?
    Do you want the data to remain on Active sheet after the dropdown is selected?

Participate now!

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

Register Yourself Login