Automated copy-pasting of results dependent on dropdown selection

[cfw_intern]

Hi guys, first post here!

I am attempting to generate both 5-Year and 10-Year enrollment projections for all 937 school districts in California. I have all the historical enrollment data saved in a bunch of different sheets, and then a master sheet where I use VLOOKUP on a drop-down selection of counties, followed by another dependent drop-down with all the districts within that county. Once a district is chosen, the historical data is pulled from the other sheets and used to generate the projection.

What I want to do is have an easy way to automatically populate a table with a district's name, its current enrollment, and its projected enrollment. Since the actual calculations are performed in pretty large table and require the use of many if statements and dependent formulas, I can't think of a way to create a formula that could accomplish this task.

Is it possible to create a macro that goes through a list of districts on one sheet and automatically selects the drop-down box (or maybe just copies the district's name into the cell and I can remove the box) on a different sheet associated with that district, then copies the contents of two different cells to the original sheet? I don't really have any experience with macros so I thought I'd ask.

Best,
an intern