• Hot Topics

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. https://dl.dropboxusercontent.com/u/...mock%20up.xlsx

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

This thread is current as of November 8, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel