Refering to More than One Sheet in an If/Then Statement

[JoseK70]

I am having trouble refering to more than one sheet in an If/Then statement.

I am looking to do

If sheet2(cell1)>100 then sheet1(cell1)=sheet2(cell1)
Else sheet1(cell1)=sheet2(cell2)

[Andrew-R]

Something like this, maybe:

Please Login or Register  to view this content.

Without knowing a bit more about your workbook structure and what you're trying to do then it's harder to be more precise.

[JoseK70]

Book1.xls

I am trying to make this a macro.

[Andrew-R]

May I ask why? The formula works, formula are generally faster than macros, they don't cause any security problems when distributing workbooks and, for simple things like this, they're easier to work with.

But, anyway, a slight modification of the code I posted above, to change the cell references to the appropriate ones should do the trick.

[JoseK70]

Thanks. See the reason I need a macro is I need to run this for an undetermined amount of people so this is the start and for some reason it wasn't working. Basically once all the scores are calculated for a person it gives them a level then I need it to run again for the next person.