Is there a way to type a word into a cell in the B column. Then for the A and C cell either side to pre populate based on what you wrote in the A and C column last time that word was put in the B column.

I hope I have written that in not too much of a confusing way.

Any help gratefully received.

Thank you