If cell A1 is .....

[teeb]

I want to create a macro that checks the value in cell A1 and if >=85% it goes to sheet2 and if <85% it goes to sheet3

Sounds simple enough but it's beyond me.

Thanks

[oldchippy]

You need to be a bit more specific, when you say if >=85% it goes to sheet2 and if <85% it goes to sheet3, what is it you want to go to sheet2 or sheet3 and where abouts you want it?

[Carim]

Hi,

Sub Test()
    Sheets("Sheet1").Select
    If Range("A1").Value >= 0.85 Then
    Sheets("Sheet2").Select
    Else
    Sheets("Sheet3").Select
    End If
End Sub