Results 1 to 5 of 5

Referencing cell on PLAN2 to a new expanded sorted cell on PLAN1. How ?

Threaded View

  1. #1
    Registered User
    Join Date
    09-03-2022
    Location
    brazil
    MS-Off Ver
    2016
    Posts
    3

    Referencing cell on PLAN2 to a new expanded sorted cell on PLAN1. How ?

    Hi.

    Thank you all for this incredible board. This is my first post.

    How can I keep referenced cells on Planilha2 pointing to correct Planilha1!B column cells when do an expanded sort on Planilha1!A column?
    Example : in the attached file you can see that

    Planilha2
    C2 = =A2*Planilha1!B1

    If I do an extended sort on Planilha1!A column, all values on Planilha1!B will change the row position and the referencing cells on Planilha2 will be lost.

    How can I keep them referenced ?

    Thank you all!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 02-22-2020, 06:46 PM
  2. Replies: 6
    Last Post: 02-22-2020, 05:20 PM
  3. Replies: 1
    Last Post: 02-21-2020, 12:32 PM
  4. Display expanded formula in cell in stead of cell references
    By vnr2583 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-24-2013, 10:06 PM
  5. Mirroring PLAN1 on PLAN2 with some conditions.
    By ToshNakamura in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2012, 11:24 AM
  6. find the next empty cell: expanded
    By stew0720 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2006, 01:59 PM
  7. Tab Key Expanded Cell Movement
    By DennisLeary in forum Excel General
    Replies: 2
    Last Post: 04-07-2006, 10:10 PM

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