Excel VBA if or function

Hi Jens,
I think the issue with my code was because that i have built in the For Loop statements within the nested IF statement, and i am not sure if i have place the For Loop statement at the right place. this could possibly caused the issue above. This only happened in very short part of my page long code.

I want the macro to read the one column on RawData page (For Loop to read through each cell in the column) then copy the correct data area over to the relevant page (For Loop to check each page on the workbook). if the worksheet does not exist then create one.

I can take the example i posted on 4th Sep to explain. I firstly used Dim to variant three "sh", "sh2", "sh3" to stand for the three worksheets and place them out of the whole nested IF statement (here is for the For Loop later to recognise the sheets). and then i place the For Loop " For Each sh In Worksheets" before the second level IF. It seems that it jumped the copy over part and moved to create a sheet directly. Any help would be much appreciated.
Thanks
Bin


Dim sh As Worksheet
Dim sh2 As Worksheet
Dim sh3 As Worksheet
Dim i2 As Integer

For i2 = 1 To 10000

If sheets("rawdata").activecell.value="Canx" then
select the data area.

______For Each sh In Worksheets (For Loop)

______If sh.Name Like "CanxData" Then
______copy the data over to CanxData

______Else: create a new data tab and name ______as "CanxData" then copy the data over

______End if
______Next

Elseif sheets("rawdata").activecell value="Definite" then
select the data area

______For Each sh2 In Worksheets (For Loop)

repeat above ...

End if
Next