Help to sort out filtered data from the data contained in another sheet of the same workbook

[No News]

Hi All

I have a work sheet with the datas as below

A B C D E
F G H I
J ------- so on.
1 P.O.# STYLE# ORD.QTY PRICE VALUE INV.NO INV.DATE
SHIP.QTY AMT.RECEIVED DATE ............ etc...
2 P-150 ABT-5 500 $2.50 $1250.00 AB/125
20 JUL 2006 476 $1190.00 26 JUL 2006
3
4
5
6
....
....
.....
goes on....

I have more than 1000 entries in an year

Now in the next sheet of the same work book I need the details as follows.

A B
1 P.O.# Here I have to select
the P.O Nos what is entered in the data sheet
2
3 INVOICE NO Here the relevant Invoice No. for
what I selected as above should apper
4
5 VALUE OF INVOICE Same as above
6
7 AMOUNT RECEIVED
8
9 BALANCE TO RECEIVE

Can any one help me please
TT

 

[No News]

Re-Posting the below as the words are suffled.


Hi All

I have a work sheet with the datas as below

A B C D E
F G H I
J ------- so on.
1 P.O.# STYLE# ORD.QTY PRICE VALUE INV.NO INV.DATE
SHIP.QTY AMT.RECEIVED DATE ............ etc...
2 P-150 ABT-5 500 $2.50 $1250.00 AB/125
20 JUL 2006 476 $1190.00 26 JUL 2006
3
4
5
6
....
....
.....
goes on....

I have more than 1000 entries in an year

Now in the next sheet of the same work book I need the details as follows.

A B
1 P.O.# Here I have to select
the P.O Nos what is entered in the data sheet
2
3 INVOICE NO Here the relevant Invoice No. for
what I selected as above should apper
4
5 VALUE OF INVOICE Same as above
6
7 AMOUNT RECEIVED
8
9 BALANCE TO RECEIVE

Can any one help me please
TT