I have a table (same as other post) with about 32 different variations of setting for a series of columns. Originally, I made 32 different worksheets (in Excel) to compensate for each set of cells. However, I realized that I could change the values of one particular cell using the validation tool. Now, however, I have to form a script that will automatically week out the 31 false values and select the 1 numeric (true) values. Since Excel only allows 7 if statements, I was wondering how I might get a macro to do more the full list. Any suggestions would be great.

will