Excel VBA - Worksheet Change Not Looping Correctly

  • Hello All.

    I am new to this forum and hoping someone can help. I have exhausted all avenues trying to figure out an excel problem. I have a worksheet with a macro attached. The macro performs different actions depending on the data entered in specific columns. for example, is a name is entered in column A, date is automatically entered in column B. When a drop down value is entered in Column L, date is entered in Column L. If data in column L = "Fees Received" or "Policy No. Issued" data is copied to another worksheet. All individual components are working. However not all the time. I am new to VBA but believe I have the incorrect logic in my code. I would be very grateful for any help.

    Sample Code.xlsm

  • Code Tags Added

    Your post does not comply with our Forum RULES. Use code tags around code.

    Posting code between


    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Participate now!

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