Results 1 to 3 of 3

Thread: Article: Replace External Links With Values

  1. #1
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,195
    Articles
    57
    Blog Entries
    14

    Article: Replace External Links With Values



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

    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #2
    The code here is great...as always! Used your site many times!!!

    However, I would like to take the code above a step further and only replace the 'linked portion of the formula' with the external value and keep the cell formula intact. But I don't know how.

    For example:
    if the linked value of "[Book1]Sheet1!$A$1" = 5

    Replace the original linked cell formula:
    =[Book1]Sheet1!$A$1*10

    With
    = 5*10

    Not just the final value of "50".

    Any ideas?

  3. #3

    Replace External links - One step further help required

    sorry somehow posted the same comment twice...I have deleted the duplicate comment with this (as I do not know how to delete the full comment )
    Last edited by scott; 2015-08-25 at 04:26 PM.

Posting Permissions

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