Add worksheet change event to add a pre specified number looking up the corresponding row value

  • Hello CapG

    Not sure why you would not just do this by seperating the text into two columns and using the vlookup function native to excel, but this code should work for the text as provided:

Participate now!

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