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


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