Excel 2010 - help needed

[tbux22]

Hello All,

I am putting together a spreadsheet for real estate analysis. I would like to set up a template that would simplify a process.

Ex. Apartment building has 100 apartments. 5 different Unit types (e.g 1bed/1 bath, 2bed/1bath). The different unit types have 5 different rent values ($500 for 1bed 1 bath, $600 for 2bed/1 bath). The different Unit types vary in size.

This obviously will be different for each building, so it is very unique.

I would like to build a worksheet that ask these questions and displays the information based on the inputs.

Step 1 - What is the total # of units in the building? 100
Step 2 - How many unique Unit Types? 5
Step 3 - How many units in Unit Type A,B,C,D,E? 10,20,30,25,15
Step 4 - How large is each unit type?
Step 5 - What is the rent for each unit type?

Rather than build a worksheet and type in each value. I would like to set something up that ask these questions and can display the info. I am not too familiar with VBA, but figured it may be the only way to get it done. So any help is appreciated. Thanks

 

[AlphaFrog]

Perhaps Excel's Autofilter feature would suit your situation.
Excel AutoFilter Basics

If you do a web search for something like Excel Autofilter tutorial, you will find several step-by-step guides and videos.

 

[Norie]

What information do you want to display exactly?

A list of all the units in a building along with their description, size and rental?

 

[tbux22]

Thanks for the help guys! I appreciate i a great deal.

That is exactly what I am trying to do. Ultimately it will display a full list of each unit along with the size, unit type, rent, etc.

Thanks

 

[tbux22]

I looked at Auto filter. I dont think that will work for what I am looking to accomplish.

I would like the setup to be user friendly so you can ask the questions and then excel would populate data based on the variables.

I am trying to avoid having to build a database for numerous projects.

 

[Norie]

I came up with this:

http://www.box.net/shared/b8d9n5i7x2udoj71tus9

It's probably overkill a bit, and it's definitely not perfect.

Might give you some ideas though.

 

[EXCEL-lence]

You could use either VBA to do this, or like Alphafrog said, autofilter

I'm guessing you want some sort of average property price on the back of the filter?

 

[tbux22]

Thanks Guys! Norie, wholly molly thats exactly the idea I was looking for. I will try to look into the coding and follow, but its exactly what I was looking for! I was looking for advice/direction but cant thank you enough for your help!