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