Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: equations between sheets after sorting

  1. #1
    Guest

    Default

    cells in one sheet referring to another sheet are no loner valid after second sheet rows are sorted;

    conditional formating apparently requires a pseudo column to make a decision regarding data in another shhet.

  2. #2
    Guest

    Default

    Test reply

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Suppose your linking formulas say:

    =Sheet2!A2

    change it to:

    =Sheet2!$A$2
    ~Anne Troy

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Stay here in the question, RR. I was just looking to see if you had replied.

    I see what you are saying now. Why would you be sorting the original information? Why don't you copy it to another sheet called "sorted"?

    Why are you linking to these cells in the first place? Do they need to be repeated? Perhaps you're not setting your file up properly?

    Why don't you give us some info about your sheets and what you're doing with them. It's always much more helpful if you give this info up front.

    Just an FYI (not yelling): Using the Private Message option is really intended for *personal messages*. Don't use it to give responses to posts on the board, unless you need to provide perhaps confidential info or something.
    _________________
    TheWordExpert

    [ This Message was edited by: Dreamboat on 2002-03-11 19:29 ]

  5. #5
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, Rick. Did not mean to tell you not to PM, because that's not what you did and I just realized it. It's okay to email me, but others on the board don't *benefit* by seeing your response. Many free tech support sites follow the *rule* that you should keep all correspondence about the question IN the question, so that others can read and learn.


    ~Anne Troy

  6. #6
    Guest

    Default

    Thanks. My first try at message board usage so I'm learning.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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