I import data form Word to Excel on a weekly basis to a sheet called John T.
I have also created another sheet called John in the same Work Book.
I have created a formula in John to check if 5 values in John T are greater
than zero(0), if they are greater than zero datafill John with GREATER THAN 0
if not leave it blank.
=IF('John T'!B100,"GREATER THAN 0",IF('John T'!B110,"GREATER THAN
0",IF('John T'!B120,"GREATER THAN 0",IF('John T'!B130,"GREATER THAN
0",IF('John T'!B140,"GREATER THAN 0","")))))
It works ok but I need to know if there is a quick way to increment this
formula by creating an Auto Fill or Series in John so I can get it to jump
ahead 18 spots on John T and have it increment all the 'John Ts' by 18 and
continue on for each 18 increment.
In other words =IF('John T'!B280,"GREATER THAN 0",IF('John
T'!B290,"GREATER THAN 0",IF('John T'!B300,"GREATER THAN 0",IF('John
T'!B310,"GREATER THAN 0",IF('John T'!B320,"GREATER THAN 0","")))))

Thanks