Update my existing macro to be able to update and delete

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


    I have a VBA macro that I have been using to update a roster with planned and unplanned leave.

    What I was hoping to do was to have the ability within the same code or a separate code to:

    - Delete requests that are no longer required


    - Change the type of planned or unplanned leave

    Here is the script that I use to add planned and unplanned leave, any help in making the above changes I would really appreciate.

  • Could you attach a copy of your file including your current macros? It would be easier to see how your data is organized and to test possible solutions. Include a detailed explanation of what you want to do using a few examples from your data and referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

    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.

  • S O

    Added the Label Cross Post
  • Troy,

    Please take a few minutes to read the forum rules you agreed to abide by when you joined. You have violated two of them with this posting.

    1. You have crossposted to other sites and failed to inform us.

    2. You have failed to use Code Tags for your VBA code. I have added them for you today.

    Please also read this link-->https://excelguru.ca/a-message-to-forum-cross-posters/

Participate now!

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