Hello! I have attached a visual to this message as an example of what I'm looking for. I'm having trouble finding VB code to plug in for this project I need to get done. Here is what I would like: when I click on "John" I want the next cell to be his name and then the red cells in his row filled in with specific numbers. Then, if I were to click on "Baker" it would do the same thing, it would fill Baker's row with his name and then specific numbers. I have about fifty names that need to have this same thing done to them. What would be the easiest way to do this? Thank you SO much for your help! 