I have all data in one sheet, for example (shortly):
Cust.no inv.vo
1407 exp10
1407 exp11
1407 exp12
2211 exppp
2211 expppr

My question is:
I also have other sheets. One sheet is for customer 1407, another for 2211.
How do I get all invoice numbers, which belong to customer 1407 to sheet one
and all invoice numbers for cust no. 2211 to its sheet? Which function do I
have to use?
The database is quite large and the only criteria is customer number.

To sum up: I only have one criteria. How do I get all its invoice numbers
from the database to its sheet?

I would really appreciate someones prompt answer!

Thanks,
Tapsa