07-12-2010, 06:08 PM
I've always found that using Excel for personal finance is like using a round peg for a square hole. A spreadsheet metaphor just doesn't work very well. I suggest you try moneydance instead. It's cheap, fairly intuitive, has a free trial, and should do everything you want.