Sorting data with VB

[poogermum]

Hi

I am new to VB in Excel and I am trying to do the following and I am wondering whether it is possible...

I have a long list of data on one sheet and a dropdown on another sheet. Iwould like the user to be able to choose somehting from the dropdown and the data from the one sheet will be filtered for that criteria and appear underneath the dropdown on the other sheet.

is that possible????

Help!

 

[VoG]

That sounds doable. Can you give specifics?

 

[poogermum]

ok... here we go...

on sheet 1 I have a table of about 20 columns - each line relating to a customer. Each customer has a customer number and is located in a sales territory. Each territory is broken down to "city", "region" and "country".

On the "analysis" sheet, I would ideally like 3 drop downs but one would do for now. The dropdown would have e.g. the region names on it. On selecting the "region" they want to see the details for, a table will appear underneath the dropdown, listing the customers and their key "sales" information for the region in question as opposed to the total 20 columns which are on sheet 1. The headings for the table can already be there before the "region" has been selected. I am just concerned about how to get the data, filtered from sheet 1 to the "analysis" sheet....

Hope this makes sense

 

[poogermum]

Has anyone got any ideas?

 

[VoG]

Why not just use AutoFilter http://www.contextures.com/xlautofilter01_2003.html

 

[poogermum]

been thinking about using autofilter but that would mean that would have to carry the entire load of data on the analysis sheet as opposed to just the rows I require.

Also I would be interested in finding out how to do this using vb. I use vb in access and find it very flexible.