+ Reply to Thread
Results 1 to 2 of 2

Linking between worksheets- then sorting data

  1. #1
    sahamill
    Guest

    Linking between worksheets- then sorting data

    I have a list in Worksheet 1, and I link some values to Worksheet 2 by using
    ='Worksheet1'B1 formula.

    When I sort the list in Worksheet 1, the value in the linked cell in
    Worksheet 2 changes as well. I want the value to stay the same in Worksheet
    2, and the formula updates. Is this possible?

  2. #2
    Debra Dalgleish
    Guest

    Re: Linking between worksheets- then sorting data

    If you sort the data in the original list, the linked data will sort
    too, and you can't change this behaviour.

    Perhaps you could store all the data on sheet 1, instead of separating
    onto two sheets. You can hide columns or rows when you want to print.

    sahamill wrote:
    > I have a list in Worksheet 1, and I link some values to Worksheet 2 by using
    > ='Worksheet1'B1 formula.
    >
    > When I sort the list in Worksheet 1, the value in the linked cell in
    > Worksheet 2 changes as well. I want the value to stay the same in Worksheet
    > 2, and the formula updates. Is this possible?



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


+ 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