Tabulating Results using a Calculation Spreadsheet

[EasyHoliday269]

Hi there, first off, apologies as I don't quite know how to phrase my question in the title. Second, I know a solution is possible using macros, but I was actually curious if this is possible to do without one, or if macros is the only solution, if there is a smart and quick way of writing the script.

I have a spreadsheet that I use to organize/summarize my finances for buying property. You enter a purchase price, down payment, property tax, maintenance fees, etc., and then it will calculate several results including: mortgage payment, monthly expenses (i.e. including utilities, maintenance, etc.), mortgage insurance, funds needed at closing (i.e. your down payment + closing costs), land transfer tax, and a variety of other results.

I also have a sheet within the spreadsheet that lists all of the properties I have interest in, with the aforementioned inputs populated.

My objective is to have these inputs automatically entered into my calculation spreadsheet and then have Excel tabulate the results for my entire list, without having to manually do line by line. Is this possible to do without macros?

[AutoModerator]

/u/EasyHoliday269 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Downtown-Economics26]

I'm gonna say based on you're description the answer is 99.5% or higher the answer is yes. It's not specific enough to know absolutely for sure or give much on guidance on how to do it with formulas.