Keep cell reference

[fishcad]

I use Excel to run wrestling tournaments in which the wrestlers are sorted by weight and automatically placed in brackets. I have one workbook for round-robin tourneys and another workbook for line-bracket tourneys. Occasionally I need to insert a bye into the list of wrestlers and have the other wrestlers move down in the list. I need the cells that refer to the "Bye" cell to stay on that cell rather than move to the next cell down. Please look at the attached images to see what I mean.

 

[jtakw]

You're welcome, thanks for the feedback.