Hey all, just wondering if this was possibly via formulae...?

So basically, in cells B2-B300 I have names, and D2-D300 I have blank cells.

But, I'd like to start inserting a "y" into the blank cells.

When I insert a "y" into the D column, I'd like for the corresponding B column name to be placed into A25. Then after inserting the next "y", for the next corresponding name to be put into A26. And so on.

eg: if B2 has "Daniel" and I put a "y" into D2, I'd like Daniel to appear in A25. Then, if I put a "y" into D13, and B13 has "Jack", I'd like Jack to appear in A26. etc

If possible, I'd like the order of the names being put into the A25,26,27 etc to be in the order that the "y"'s are manually inserted.