Forum Discussion
Auto populate rows based on information from another sheet
You've had over 50 views and no responses so far. I suspect people might be just not sure how to advise, because the brief description you've given raises more questions than you might realize.
I say that because I suspect, first of all, that it's fairly easy (for those who know how to write a macro or VBA routine) to tell you how to have those responses to the questions on the first page create the corresponding number of rows on subsequent pages.
But once that's done, what is the rest of the job? That part is easy (at least that's my guess, as noted), but you could help us help you if you would be so kind as to flesh out the bigger picture. What kind of information then gets put into each of those five rows of single family properties, or the three rows of multi-units. And what happens with that information once it's put in? Are you (or are your users) selling these properties, renting them, managing them, cleaning them....???? What will you be tracking? What happens when another property gets added to either category? What happens when one gets taken off the list?
I can well appreciate why you want to keep it simple by asking a simple question or two, but there would seem to be other questions that will need to be answered to make it a useful workbook. And from the description you've given, there seems to be little justification for that macro or VBA routine to create five or three rows, rows that still will need other information, presumably more sophisticated responses on the part of those same users.
Why not just have them fill in five (or three) rows, adding a row as they go? That's even simpler, in many respects.
I don't mean to be difficult in asking these questions. If we were sitting down face-to-face, these are questions I'd be asking. As I said, your own opening question raises more questions. And I strongly suspect that's why you've so far not gotten any replies....
- I just used basic/quick examples to get my question out there. I am making a workbook for investors to be able to use to help manage their properties, some may only have 2 or 3 properties while others may have 50+. I haven’t used excel to this degree in quite some time but have in the past and was very good at it. So, a lot of it comes back to me once I start working on a project.
I want the rows to auto populate and auto populate the criteria that I have for each column/some will have dropdown list (address, city, state, property type, etc…) I get that 2 or 3 is not a big deal to manually input, but the problem is there is a wide base of clients and that means some may be tech savvy and others just might know how to turn the computer own. Yes, I can help a client or 2 figure this out, but when there are 500+ clients and I am the one who has to manage them all, I want to find a way to make the process a little easier for me. The whole workbook itself will be used for many different options. It will be used to just manage a property/properties as a whole, to include financing, repairs/rehabs, also it will be used if an investor decides to sell it off to another investor. Each sheet will have different information for the user to personally use but have the capability to send off if it needs to be to another individual. Like most need to get funding for rehab purposes and the hard money lenders need some information so it becomes easier for the individual to pull up from one document.
I just wanted to know how to do this. I know there is a way, I have a template that I received a few years ago and the workbook is password protected so I can not get the formulas/codes used and I can not remember where/who I even got the workbook from, but that is how they have it set up.
I wanted to see if there was a simpler way to achieve this without having to use macros/VBA. I guess Ill dust those skills off and conquer this. Thank you for the time to respond.
