Which function?

[Guest]

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

 

[Guest]

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.

 

[Ron de Bruin]

Look here
http://www.rondebruin.nl/copy5.htm

You can do it manual like this (also on the page)

Copy the filter result :
1) Be sure that the active cell is in the data range
2) Press Ctrl * to select all data or use F5>Special>Current region>OK
3) Press Alt ; to select all visible data or use F5>Special>Visible cells only>OK
4) Ctrl c or Edit>Copy
5) Insert>Worksheet
6) Ctrl v or Edit>Paste
7) Select the sheet with the filter ( Sheet("Netherlands") in my example )
8) Press Esc
9) Press Alt d f f or Data>Filter>AutoFilter to turn off AutoFilter

I have also a add-in that can do it for you
http://www.rondebruin.nl/easyfilter.htm