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.

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.

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