Thanks for the effort. My thoughts:
- rows 1-6 are irrelevant to the calculations. No need to move them into the blue section like you did.
- You have shifted rows 24-27 to the right. Those cells need to align with rows 22, 30-34.
- I didn't see any changes to the formulas in rows 26, 30 which are my problems. I can't calculate the values in those rows. I need to refer to the other worksheet.
- You think this was a lot of numbers? I deleted 3/4 of the worksheet before I sent it to you. Look at rows 36-48. All those go into the year's income/expenses. Look at rows 52-55. those are the components of net worth. Calculating the mortgage is just one expense. apartment equity is one component of net worth.
06-09-2020, 12:46 PM
progress
Similar Threads
Input data in Excel and get info from Access
Windows 10 
Office 2010
Hybrid Mode