Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi line records (2003)

    I have a workbook with records that span 2 lines. I have to do a mailmerge with those records.
    The idea is to make a new sheet with the fields I need. With ADDRESS() I can get the the addresses I need.
    What formula do I need to get the content of the cells.
    TIA
    Attached Images Attached Images
    Francois

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi line records (2003)

    Say that B3 contains sheet1!$A$6, as in your screenshot. The formula

    =INDIRECT(B3)

    will display the value of Sheet1!A6.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi line records (2003)

    Thanks Hans, work like a charm.
    Francois

Posting Permissions

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