Macro for Number Sequence

  • Hi can anyone help me creating macro?
    Please see attached.
    Sheet 1 - Input details
    Sheet 2 - Output details


    Requirement: Only column A will be updated
    1. If value of Column B and C are the same then value in Column A is the same
    2. If value in Column B is '-" then column A will proceed with sequence


    Thanks in advance!

  • Hello,


    From your explanation, it would seem a simple IF function could handle the sequence ...


    Attached is your test file


    Hope this will help

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)