I'm sorry that I could not make you understand. It's my discrepancy. Actually
I want that whenever enter data in client database it automatically copy that
data which Pan No. ("PANNOTAVBL") or Received Date is same to another sheet.
I would not like to use filter. For this reason I need your help to do the
same by using formula. So is there any advice. Thanks in advance.

"CLR" wrote:

I'm not sure I understand exactly what you want when you say " So is there
any formula to extract data as above without using filter data ? "

Now that you have all the data on the one sheet, using the AutoFilter is the
best way to extract only the rows you want. Just run the Autofilter, select
the conditions you want with the drop down arrows, and then copy and paste
the results over to another sheet if you wish.

Post back if you still are having problems.

Vaya con Dios,
Chuck, CABGx3




"Montu" wrote in message
...
Thanks for your advice. I have put all data in sheet 1 according to you
advice. Now I want extract & put data in another sheet whose "Receive
Date"
or "Pan No." ("PANNOTAVBL") is same. Because I have to asked for Pan No.
to
those party who has no Pan No. i.e. "PANNOTAVBL".
So is there any formula to extract data as above without using filter data
?
Help me.

"CLR" wrote:

I would advise that you put all your data on Sheet1 instead of 3 sheets,
and
then just use the Data Filter Autofilter feature to do the desired
filtering. Otherwise, you would have to filter all 3 sheets and combine
the
results on a 4th sheet.

Vaya con Dios,
Chuck, CABGx3





"Montu" wrote:

We have to maintain our client database like
A B C
D
1 Receive Date PAN No. Name Address
2 16/01/2008 ABCDE1234F ABC & CO. Nagpur
3 16/01/2008 PANNOTAVBL XYZ PVT LTD. Kanpur
4 17/01/2008 PANNOTAVBL NTCP INTL Kolkata
to be continued.....
now I would like to extract the data from this databse whose received
date
or pan no ("PANNOTAVBL") is same in sheet 2 & 3 respectively.
so is there any formula to do this same, thanks in advance