I just downloaded an income/expense template from Zillow to manage my rental properties. The template works great but it's only set up for 5 houses and I need more columns as I own more than 5. In the attached template the houses are listed by property codes and that is the column that I need to add to. Any help would be greatly appreciated as I am completely new to working with excel. Thank you
Here is an expanded version of the template. It was just a matter of inserting columns then copying the sections already created and changing the titles for each. The SUM formulae were expanded to include the added cells.
Version 2 has amended formulae that you might want to use instead of the long formulae that require manual editing when adding columns. The formulae are in the yellow cells.
For some reason, I couldn't save the file downloaded back in .xls format so seeing that you have 2013, I changed the file format to .xlsx .
Last edited by newdoverman; 06-25-2014 at 06:55 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I forgot some of the totals in the first 2 uploads. They should be corrected with this. I also added borders to the groups to make it easier to see each one.
Thank you so much newdoverman! So can you explain to me how you actually expanded the property codes within that column and how you would get those changes to reflect within the rest of the spreadsheet? I have roughly 50-60 properties that I need to set up within this format. Would I be better off using multiple excel files each containing a smaller number of properties to make it easier to navigate within each spreadsheet? Thanks again
Oh wow! 50 - 60 properties! Do you realize that there will be 180+ columns?
The formulae in the yellow areas of workbook V4 use SUMIFS instead of using the addresses of each individual cell to be summed.
This workbook has enough columns filled in to accommodate approximately 60 properties. The unused columns are hidden. They also don't have an ID so that is up to you to fill in.
Re: Need help adding columns to accounting template
Thank you so much for modifying this spread sheet! I tried several times last night to make adaptations to the original, only to go to sleep very frustrated.
You've made my work become a whole lot easier!
How does the original differ from what I sent to you? The workbook that I sent to you has hidden columns between column AH and GC. If you need access to these columns, just select both columns, right click and choose UNHIDE.
If the problem is something else, please explain with a workbook and explanation of what isn't working for you.
@newdoverman
Great to see you on the Excelforum again.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
@ oeldere
Thank you. I miss the activity here but I'm still going to take it easy. I'm really feeling exhausted for some reason...I'm hoping that some "days off" will fix it. I do however feel an obligation to try and deal with questions that are likely addressed to me. (like this one) .
Feel free to jump in if the OP sends further information. It would be appreciated by both of us I'm sure.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks