Hi,

I work in a small company with offices in multiple regions and I am trying to make an easy estimation model for sellers to see the final GM (General Margin) on the sales price they offer to customers. As each region has a set of unique cost, what I am looking to do is the following;

Have a drop down list where the sellers choose which region they represent, and then depending on which region they choose Excel lists a number of fields which needs to be populated. I can do this by creating dependent drop down lists, but then I have to repeat the location for each cell, which doesnt look nice. I am looking for one cell with the region and then followed by mutliple new cells which they need to populate.
I.e. You choose New York, then you need to populate Sales Price, Salary, Travel cost, however if you choose San Francisco you would need to populate Sales Price, Salary, Housing Cost, Car Cost, Pension Cost etc. The point beeing that you only pick New York or San Francisco once and all the new fields show up.

Anybody know how to do this?

Thank you!