Sorting Data and Dsiplaying it

[Elite311]

Hi I'm Working on a project and am completely stumped, I know it's possible to do but can't seem to figure out how to get it to work. I have tried numerous things but can't get anything to do what I'm after I'm thinking VBA would be the way to go but never used it before. Just looking for some help to get started.

What I'm trying to do is.... I have pulled alot of data into a list on a sheet, and on the first sheet I want to be able to get a quick overview of all the data in the list sorted by different criterias. Basically I want to pick region and it populate the list of things below from the data on the other sheet and as I select more options it narrow the search down. Right now all I want is to Be able to sort the data by region, and it show everything for that region, then region and market, then region market and tech.

Any help would be appreicated.

[StephenR]

I would consider using AutoFilter which is built-in and does pretty much what you ask, although the format may not be exactly as you wish.