My query is this:
I have created a questionnaire answer template comprising of two worksheets.
One contains the answers and the second is a score sheet that links to the
cells in the answer sheet.
When linking cells between the workbooks, the numerical ones are fine.
However, a lot of the answers are in text form so to get round that, I set up
text boxes in the score sheet to link to the cells in the answer sheet. That
almost works apart from one thing:
As I type the text in the cell in the answer sheet, the text box in the
score sheet does not carry all of the text. Some stop in mid-word and I have
tried making the text box bigger, wrapping the text, but to no avail. I
wonder if anyone had any ideas? I'd be really grateful!