Drop down Lists to pull data

starry436

New Member
Joined
Sep 4, 2018
Messages
1
I would like to be able to pull and combine data using drop down lists..so for example, I want to analyze financial information on my properties all combined as well as individually. So in my drop-down list say I have these to choose from:
ABB LLC (combined)
Apple Street
Gold Street
Blue Street

So those are listed in my drop down box, now I want to be able to select ABB LLC and have it pull data from all 3 of those properties and give me totals. Additionally, if I just select one property, Apple Street, I want to only see data pertaining to it. I also want to be able to say I only want to see combined data on Apple and Gold streets and be able to select them from the drop down and have their combined data display.

Can anyone help me on how to get, started? Is this possible? Basically I want to be able to combine any of my 50 properties and get data output individually or combined. My financial software cannot combine properties to show overall totals. I'd have to pull the Financials on each individual property and add them up manually.
Also, I'd like to make the data interactive on the web, so if I want to be able to send the drop down Lists to someone and they can select properties to view totals.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Forum statistics

Threads
1,226,730
Messages
6,192,703
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top