Dear All.

Please could someone help me with a query that I have.

I have a spreadsheet, which on one sheet contains a whole load of data by
region, which I am trying to summarise.

On another sheet I have set up a summary table that I want to populate,
depending on the region that I am interested in.

I have created some dependent drop downs, so that it would allow me to
select the region that I am interested in.

I want to be able to select the region from the drop down and it
autopopulate the summary table with the information from that region.

I am not sure which function/combination of functions I should use to do
this though.

Any ideas would be welcomed.

Thanks.