Hello everyone,
I have been making my own budget in excel, one reason is to teach my self more about excel and another one is too keep track of what I'm doing with my money.
I had this working before, I have no idea what I did to make it stop working, I looked on several tutorials and the error dosn't help me at all.
What I'm trying to do, I pick what category my expense is, then the cell on the right side of it sense what category I picked, goes to management sheet and makes a list of corresponding list with the same name.
When I reference my other list through Validate and I type inThis is where I pick what category my expense is and it's left of this Cell where the above code is written in through Validate.![]()
=INDIRECT($D$5)
and I get following error: "The Source is currently evaluates to an error. Do you wish to continue"
In my head I go, well... thanks for at least trying to help me. I have looked if my names was not the same, but they are and I tried re-doing everything from scratch as well.
When I type in following:or![]()
=INDIRECT("RC[-1]",0)
It dosn't reference the correct NameList that I have created and linked under the Management Tab, it just let me pick the same name as the left cell is.![]()
=INDIRECT( "D" & ROW() )
I hope I make myself clear and I have attached HomeBudget2014_Help.xlsx my excel sheet as well
thanks in advance =)
I realize that I should have post this in the Mac part, if someone can move this, that would be great! thank you =)
Bookmarks