Auto fill formula VBA with constant rule

[garypea123]

Good Morning,

New to VBA but becoming more and more accomplished with your guys help

So here is my question regarding my next script.

From Column E this is a data export (so not changeable from report). The lines will change each hour potentially, but the constant:

The word ordered in Column F, and a name in Column E (to the left).

Now what I want in column B which:

Will return a blank if the adjacent result in column F is ordered.
Will return the name of the person in Column E if (to the left of ordered) until the next ordered in the further down the column. And then repeat until the end of the data in Column F.

I have provided an example of what it should look like.

I hope this makes sense.

 

[garypea123]

Perfect, makes absolute sense and now I understand why this was not working.

Either change the code name in VBA editor or apply a slightly different script with Worksheets("sheetname").

 

[eirikdaude]

Exactly - I like using codenames because it stops users from changing the name and screwing up the script

 

[garypea123]

Yes, that makes sense completely, and definitely something I should consider moving forward. It just adds that little bit of a fail safe as none of my guys will know how to change a code name

This site is great and thank you for your help. I learn so much.