VBA Looping with Ifs

I am pretty new to VBA, however i have been tryinig to crack looping macros, and had a bit of success with it so far. However i cant seem to get this one. What i want the macro to do is go down column AW from row 6 down. Every time it encouters a 1, i want it to go to column b in the row the 1 is on. If that cell contains a 40, i need it to replace it with an "11". if the cell contains a 50, i need it to replace it with a "01". Then, on the same row, in column C replace what is there with a "Cook". Once this has ended, continue down Column AW till it reaches another "1"

Here is my attempt so far, any help with this would be amazing!

Please Login or Register  to view this content.

Looks Like maybe you missing the 1 at the begining of your Instr(1,Z,"1")

But heres another was without the range. Easier to manage I think

Please Login or Register  to view this content.

This should do it for you. You had it looking in column Z for a 1

Please Login or Register  to view this content.