Dave,

I don't think that the automatic/manual setting can speed up the program at
all, because this data has not yet been used in any calculations, there are
only a few columns of data at this point. However, I am performing this on
835 rows, so maybe it won't get any faster with less IF statements. However,
for whatever reason, when I tried the code you suggested, I got a an error
about the Next, saying

Error: Next without For.

Does anyone know what this means, and how to bypass the problem. The code
works fine using three separate IF statements, it just seems like there
should be a way to condense them into one.