Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    linking text cells

    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.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: linking text cells

    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.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: linking text cells

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

    Thanks
    Attached Files Attached Files

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: linking text cells

    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

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: linking text cells

    Thanks, It works just fine now.

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •