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






"No News" <nonews@nonews.com> wrote in message
news:eX3lxMlsGHA.4612@TK2MSFTNGP06.phx.gbl...
> 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
>
>