Results 1 to 2 of 2

Thread: Urgent help with autofil!

  1. #1

    Urgent help with autofil!

    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi all,

    In column "B", i have a formula based hyperlink that transports the user to a certain sheet once clicked on, the formula is shown below.

    =IF(Sub!A51 = "", "", HYPERLINK("#Sub!"&ADDRESS(MATCH(Main!A50, Sub!A:A,0),1)))

    My spreadsheet also requires that you constantly add new rows, but once a new row is added, the last cell in column "B" always inconsistent with the column formula. please help and advise me on how to resolve this issue as quickly as possible. please remember that is has to automatically update by itself.

    thank you so much!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Mississauga, Canada
    Excel Version
    Excel 2016
    Is Main the sheet this formula is in? If so, try removing that name. e.g =IF(Sub!A51 = "", "", HYPERLINK("#Sub!"&ADDRESS(MATCH(A50, Sub!A:A,0),1)))

Posting Permissions

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