Sorry, just saw an area of my request that may cause confusion:

2.) in the IF statement itself........... and if so for cell "AB" in the row
it is checking to = 100, if not.........

What I am looking for is for the Cell AB of the each line to either equal
10, 1000, 100 or 0 depending on the results of the code


Thanks again in advance for any help