Thank you for your response, however I have not been able to make this work when I try. I have edited the post above to clarify the column titles. I was using "A, B, C" as placeholders. They were not meant to be confused with the standard column names provided by Excel. So all of column A will be used to input the names and all of row 1 will be used to name column titles corresponding to an instruction code. The X's will only be placed in cells from B2 down and to the right.

I have tried to look through the formula you provided and understand each function and what is going on but I am unable to understand most of it individually. A apologize that I cannot follow along with this because of my lack of experience using Excel in this manner.

Also, is this infinitely expandable?