Hello All,

I have been browsing, but cannot find the solution.. Here is the case:

I have an access database export, which I need devided up in parts,
based on cell values in one of the rows of the db extract. These
entire rows should be exported to a new sheet..

So:

I have a small table on sheet 1:

Netherlands
Belgium
Luxembourg

and a big bad database with countries in column B, on sheet 2..

What I would like is to make a macro, which starts looking for the
first value (Netherlands) in the database, and exporting the matching
rows to a new sheet. And when done, starts to look for Belgium and
copies those results under the Netherlands rows in the new sheet. And
so on, and so on ;)

Hope somebody can help me out on this one, it would really be a help!

Regards
Edwin