I'm in the process of creating a spreadsheet and was wondering if someone could tell me what I am doing wrong.
I am trying to recap people's responses to a survey. Most of the questions are Yes/No answers and are no problem. However the last question asks for comments. I've built the spreadsheet with a seperate page for each client company, then within each page the responses from the individulas at a given company. I have up to 4 comments on each page. On my recap page, I would like to have all the comments appear.
However if I try linking the cells I want the comments to appear in they show as "+'Prop A'!B11:M11" rather than displaying the actual comment that was in the cell. That happens when the cell is formatted as text. If I format the cell as numerical then I get #VALUE!. Is there any way other than cutting and pasting the contents after they are entered to get this information into my recap page?
Any help would be greatly appreciated. Thanks.