linking text cells

Topic

New Reply

HI,

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.

Reply | Quote

Replies

It’s unclear how you want this structured. Have you tried using “&” and =Concatenate() to link text cells? Attach a small sample of what you are looking to do if this doesn’t help.

Reply | Quote

Here’s a copy of the spreadsheet. If you look in cell AK11, you will see where my problem is.

Thanks

Reply | Quote

Try the following formula in AK11: =’Prop A’!B11

Because you have merged B11:M11, there really is only one Cell, i.e B11. So there is no need to use B11:M11.

Hope taht sorts it for you,

Regards,

Andrew

Reply | Quote

Thanks, It works just fine now.

Learned something new today, will have to watch for that in the future.

Reply | Quote