If / ElseIf within For Each?

Hey guys, I'm looking to put a few if/elseif conditions within a for each loop. Is this possible/ any suggestions as to how I can get it to work?

Sub rating()

Please Login or Register  to view this content.

Thanks for the help!

Please Login or Register  to view this content.

Awesome thank you! But I keep getting a runtime error '9'

If it is on this line

Please Login or Register  to view this content.

You do not have a sheet name "Orig File". Make sure you have the name on sheet collection and spelling is correct.

Ahh okay that fixed it, thank you!