+ Reply to Thread
Results 1 to 2 of 2

Linking worksheets

  1. #1
    Linking Blank Cells
    Guest

    Linking worksheets

    I am linking a cell in 1 worksheet to a specific cell in another worksheet,
    both within the same work book. The cell I am linking from is blank, but when
    I link it to the other work sheet it shows up as the number zero. How do get
    the recieving cell to show exactly what is in the sending cell?

  2. #2
    Peo Sjoblom
    Guest

    Re: Linking worksheets

    You need to use a formula

    =IF(linked_cell="","",linked_cell)


    --

    Regards,

    Peo Sjoblom


    "Linking Blank Cells" <Linking Blank Cells@discussions.microsoft.com> wrote
    in message news:6A437FB5-93C4-44C6-8A90-839D38C6E183@microsoft.com...
    > I am linking a cell in 1 worksheet to a specific cell in another

    worksheet,
    > both within the same work book. The cell I am linking from is blank, but

    when
    > I link it to the other work sheet it shows up as the number zero. How do

    get
    > the recieving cell to show exactly what is in the sending cell?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1