Copy row to another sheet depending on drop down list selection

  • Go to Best Answer
  • Where is the drop down containing "change order"? Does the Change Order sheet need to be created? I don't see it in your file. Please clarify in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data.

    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.

  • Pessoal,


    Desculpa perguntar aqui, mas rodei o forum inteiro e nao descobri como criar um tópico novo

    Deve ser a pergunta mais idiota que vcs vem hoje, mas eu nao achei

    Alguem pode me ajudar?

  • Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Bids 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 I.

    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.

  • Now, one last thing.


    If I want to add another drop down list to column J to do the same thing only to different sheets.


    What portion of the code do I change to reflect that? Can you highlight were I should change the column? and where I should indicate how to copy to another sheet.


    Example: I am now going to make a drop down list in column "J" that have the options : Not awarded, Awarded, Working, and Completed ready to invoice.

    How do I add that in?


    Thank you!

  • I have added a new drop down in column J to do the same thing as before. Copy row to corrilating sheet.

    How do I code this in as well? Please see previous comment for more details. Thank you!

    Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your Bids 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 I.

    • Best Answer

    Try:

    Please note that you have misspelled the sheet name "Not Awarded" in your file.

    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!