nk into onenote 2016 paragraph from excel 2016 cell

Discussion in 'OneNote' started by optionzz, Apr 18, 2016.

  1. optionzz

    optionzz

    Joined:
    Feb 24, 2013
    Messages:
    3
    Likes Received:
    0
    I use OneNote extensively during daily operations, but keep detailed transaction records, and create reports in Excel.

    I need to insert a link into an excel cell that points to a paragraph in a onenote notebook. When reading the excel report, which has summarized data, clicking on the link would open the page with the paragraph linked to (in OneNote).
    I have one screen with Excel, and the other with OneNote. See screen print below.

    I've been able to do it only by manually creating a link in excel, and pasting in the paragraph address from OneNote.

    Pasting the OneNote link into an excel cell only pastes the TEXT content of the link, but there is not "URL" in the line in excel.

    TIA for any ideas. I could write VBA code if I could just see how to make it work!

    Pete A
    upload_2016-4-18_12-0-47.png
     

    Attached Files:

    optionzz, Apr 18, 2016
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. robfiled

    OneNote 2010 Folders Issue

    robfiled, Apr 21, 2011, in forum: OneNote
    Replies:
    0
    Views:
    1,391
    robfiled
    Apr 21, 2011
  2. tschroder
    Replies:
    1
    Views:
    3,965
    pendpete
    Jan 23, 2012
  3. rafath16
    Replies:
    0
    Views:
    3,066
    rafath16
    Jul 26, 2011
  4. stormlovr

    archiving Outlook emails in OneNote

    stormlovr, Aug 22, 2011, in forum: OneNote
    Replies:
    0
    Views:
    1,262
    stormlovr
    Aug 22, 2011
  5. bdmeehan
    Replies:
    0
    Views:
    1,042
    bdmeehan
    Sep 21, 2011
  6. hklarsen

    OneNote as mail recipient

    hklarsen, Feb 28, 2012, in forum: OneNote
    Replies:
    0
    Views:
    1,218
    hklarsen
    Feb 28, 2012
  7. jman0war
    Replies:
    0
    Views:
    4,624
    jman0war
    Apr 24, 2012
  8. Antonio Dominion
    Replies:
    0
    Views:
    234
    Antonio Dominion
    Apr 17, 2016
Loading...