Selecting data from large (greater than 7 elements) set in Excel

[willsteele]

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

[salvelinus]

This is the type of reason I hate Excel.
Anyway, at a rough guess, could you give the records in Excel an id corresponding to their worksheet? Save you from having 32 sheets. Then write code to loop through 32 numbers in the id field.

[willsteele]

Can you do an example line in the VB for me. I don't know any VB, but can replicate something I see correctly once I get the concept. Thanks very much!

[salvelinus]

No.
Do some work yourself & I and/or others will help you. If you won't try first, don't expect others to do it for you.

I don't know any VB, but can replicate something I see correctly once I get the concept.

That is one of the stupidest things ever posted.
Sorry if this sounds cranky, but that's how I feel.

[willsteele]

No.
Do some work yourself & I and/or others will help you. If you won't try first, don't expect others to do it for you.

That is one of the stupidest things ever posted.
Sorry if this sounds cranky, but that's how I feel.

This is much like telling a baby, "Walk by yourself. I don't care if your legs are unstable and weak," even though the child is looking for you to extend your hand. Cranky indeed.

I'll try to figure it out myself. Thanks for the help.