Hi

For the sake of ease I'll get right to the thick of it!

What I have is;
2 sheets, start and data.

- On data i have my sourcedata (surprise!), the first five columns are "hierachical" levels, ranging from country, to region to area and all the way down to individual branch - the rest of the columns (6-33) are just data.

- On start I have 5 comboboxes, 28 checkboxes and one commandbutton

What I wanted to happen was;

In Combobox1 I wanted a listing of the countries (column A in data). Then combobox2 should show all off the regions (column A) that is in the country chosen with combobox1. And so forth with the rest of them.

Finally the user should check of which information from data (columns 6 - 33), he wants to include in his table, then press the commandbutton and the specific report should be generated (by copying the selection from the data sheet onto a new sheet).

My Problem is;
1 - I'm a complete rookie when it comes to comboboxes - I only know additem (which I will then need to state manually everytime it changes) and then I just found listfillrange - the problem with this is it doesnt filter the list shown - so I have Ireland showing up some 2000 times!

2 - I don't know how to fill the comboboxes 2-5, as stated previously. I guess what I need is something like autofilter - but I don't know if it can be controlled from VBA?

Any help would be greatly appreciated!!