+ Reply to Thread
Results 1 to 6 of 6

Need Help Finding What Name Manager is Referring Too?

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    502

    Question Need Help Finding What Name Manager is Referring Too?

    Hello,
    A few weeks ago I posted a question regarding needing a formula that shifts and adjust when new data is added. A member was kind enough to create a spreadsheet in attempt to find the answer I was looking for but unfortunately what he created put me on the right path but didnít quite get the job done.

    Since then I have made some changes to the workbook and it works fine with the current data but when I paste in new data all of the formulas are out of whack. I think the problem has to do with something that is referred to in Name Manager but I canít figure out what itís referring to. I hit Ctrl F3 but I can't figure out what means [db!] in the Name Manager? I see it refers to something but I canít figure out what it refers to. I think thatís what needs to be changed.

    Link to original post:
    http://www.excelforum.com/excel-form...t-updates.html

    Please see spreadsheet for a better understanding.

    Any and all help you could provide for any of the formulas or figuring out what db! is would be greatly appreciated. Thank you.
    Attached Files Attached Files
    Last edited by artiststevens; 06-07-2014 at 05:20 AM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,425

    Re: Need Help Finding What Name Manager is Referring Too?

    usually you can find the reference cells by going to name manager that i think is under the data tab (in my home version of excel for iMac it is under tables tab) but when you find the name manager and open it, it will tell you what the range is that the table refers to. You can edit it there. You can also see it in the cell reference window in the far left of the function window when you highlight that area.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: Need Help Finding What Name Manager is Referring Too?

    Hi artiststevens,

    db is nothing but name of the sheet which was hidden, kindly unhide the db sheet and you will be able to figure out what needs to be change(Check H14 cell in db sheet).


    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  4. #4
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    502

    Re: Need Help Finding What Name Manager is Referring Too?

    Thank you very much Paresh! I greatly appreciate the help... I never stop to think of that. :-)

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    6,671

    Re: Need Help Finding What Name Manager is Referring Too?

    Pl see attached file with only Tab db with formula.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    502

    Re: Need Help Finding What Name Manager is Referring Too?

    Quote Originally Posted by kvsrinivasamurthy View Post
    Pl see attached file with only Tab db with formula.
    Thank you very much kvsrinivasamurthy! It's greatly appreciated! I'll review it now.

+ 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. Name Manager
    By Layo909 in forum Excel General
    Replies: 1
    Last Post: 07-09-2011, 03:38 AM
  2. Using the Name Manager with VBA
    By iamtehwalrus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2010, 11:49 AM
  3. Name Manager Help
    By geim9000 in forum Excel General
    Replies: 0
    Last Post: 08-19-2009, 04:47 PM
  4. Name Manager
    By d0n in forum Excel General
    Replies: 6
    Last Post: 06-09-2009, 01:39 PM
  5. Replies: 3
    Last Post: 04-03-2008, 03:16 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