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.
Bookmarks