Which function?
 

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

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

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 F5SpecialCurrent regionOK
3) Press Alt ; to select all visible data or use F5SpecialVisible cells onlyOK
4) Ctrl c or EditCopy
5) InsertWorksheet
6) Ctrl v or EditPaste
7) Select the sheet with the filter ( Sheet("Netherlands") in my example )
8) Press Esc
9) Press Alt d f f or DataFilterAutoFilter to turn off AutoFilter

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Simon Letten" wrote in message ...
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