You could use an Autofilter on the database to display all the records
belonging to just 1 customer and then copy & paste the visible data to the
relevant worksheet. I'm not sure that there is a function that will actually
move the data for you, you'll need a macro if you want to automate moving
data around.
--

Simon


"Tapsa" wrote:

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