+ Reply to Thread
Results 1 to 5 of 5

Replacing values in existing functions with newly defined names

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    San Ramon, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Replacing values in existing functions with newly defined names

    I'm trying to simplify a spreadsheet i've been given by defining names for certain values. I'm using Excel 2013. Is there any way to have all of the newly defined names I've created for cells automatically be inserted into all of the formulas that exist in the spreadsheet?

    Example.
    Old formula in one sheet of a workbook looks up a cell in another sheet with the value of ='sheet1!A1

    I've given the value of cell A1 in Sheet1 a name of dgwd.

    How do I get every formula in the workbook that references 'sheet1!A1 to change the value within that formula to dgwd?

    Thanks in advance.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Replacing values in existing functions with newly defined names

    Have you tried find and replace?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    09-16-2013
    Location
    San Ramon, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Replacing values in existing functions with newly defined names

    I'm pretty sure that would work just fine, but I've got a couple of hundred names I've defined for commonly used values in this workbook. I was hoping there was a more "automatic" process I could use that would scrub the workbook and replace the values.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Replacing values in existing functions with newly defined names


  5. #5
    Registered User
    Join Date
    09-16-2013
    Location
    San Ramon, CA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Replacing values in existing functions with newly defined names

    I tried using that, but I get an error that says "Microsoft Excel cannot find any references to replace."

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I apply globally defined names to newly inserted templates?
    By Manzomanen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-15-2012, 07:23 AM
  2. Defined names referring to nonexistent range won't pick up once existing
    By nofzinger in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-18-2010, 11:12 AM
  3. Newly Created Sheets Replacing Existing
    By degmania in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-20-2008, 04:04 PM
  4. replacing defined names for ranges
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2006, 12:10 PM
  5. Replies: 0
    Last Post: 04-06-2005, 07:50 AM

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