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)
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)
Something like this, maybe:
Without knowing a bit more about your workbook structure and what you're trying to do then it's harder to be more precise.![]()
Please Login or Register to view this content.
Book1.xls
I am trying to make this a macro.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks