Very stuck plz help

[cartwright4]

I'm not sure if this is possible but I want to try..

So, i have an if ffunction, if its true than I want C1 to ="X". Then when i run it again if its true again I want to "push" or what have you, the first X to D1 and take over C1. The best way to explain it is like baserunners in baseball, a man on first, then if its true again man on first and second. etc..

 

[diddi]

this would require vba i would think

 

[Nanette]

can you give a bit more information please?