rolling budget row delete: invalid cell reference
Attached is a really simple rolling budget I use in Excel.
What I'd like to be able to do is delete row 3 (Sun 10-21) and have the rows below shift up without getting a #REF error in the balance column. Any ideas?
It seems like a pretty straightforward row translation, and the formulas couldn't be simpler. I've tried some absolute vs relative positioning tricks, and I could write some VB if I had to, but I'm hoping I'm just missing something really simple.
Thanks!
-Colin
Hello 6cef,
Welcome to the Forum.
Since it is a rolling budget with row formulae depending on each other, you cannot delete any of those rows.
Best you could do is to clear the data in a Row from Column A through C.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks