Excel: Dynamic Performance/Potential 9 Box Grid in Excel

I don't know if this is an easy thing to do. It could be worthy of a duelling podcast between Mr.Excel and Exelisfun :-). I've attached a link to a source file that shows an example of what I'm aiming to do. Basically a 9 box grid exists. If a person in the list below is given a number between 1 and 9 a 'dot' shows up on the grid. If the number changes then the dot automatically moves to the new box number. I'd appreciate any feedback on how to do this or if it can even be done. I'm stumped. Thanks in advance, Alan. 

This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of November 08, 2013.

For more resources for Microsoft Excel