auto-populate cells to display text from another cell without cutting off text?

I am trying to auto-populate text in cells in area A, based on data I enter into other cells in area B. I want the area A cells to be for display only, as all editing will be done in area B. The problem I need help with is: how do I do this such that the text I write does not get cut off if is longer than the column width? See the attached document for a clear example and description of what I am trying to do...

Thank you VERY MUCH in advance. This is for an important project in grad school.

Jessica

Thank you, but unfortunately that won't work. I have added an edited file showing that I need text to sometimes span the length of all the columns, and other times only fill one or two columns.

Hm, I am not sure how to attach another file to this thread...

Oh figured it out, here is the updated file.

I see. Thank you.

Hi aerorun87

So would a bit of VBA that simply copies the right box to the left box work? It could be automated to fire off any time a cell within the right box is updated.

Regards
Alastair