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

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

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

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

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

If this is not close to what you want,
mark it up and upload it.
http://www.freefilehosting.net/download/3agj9

Hi, as per your advice it's not close my demand.
I just want whenever put date in E7 (letter sheet) the acknowledgement no.
will be copy from received sheet & in B18 (letter sheet) date should be copy
starting date inrespect of sending date (that means letter date & sending
date shoul match) as shown in letter sheet. simultaneously in PANNOTAVBL
seet also copy whose PAN No. ("PANNOTAVBL") from Received Sheet. For make you
better understanding I'm upload a excel file (Test.xls) in following url
http://www.freefilehosting.net/download/test.xls

Thanks in advance.

"Herbert Seidenberg" wrote:

If this is not close to what you want,
mark it up and upload it.
http://www.freefilehosting.net/download/3agj9

Hi, as per your advice it's not close my demand.
I just want whenever put date in E7 (letter sheet) the acknowledgement no.
will be copy from received sheet & in B18 (letter sheet) date should be copy
starting date inrespect of sending date (that means letter date & sending
date shoul match) as shown in letter sheet. simultaneously in PANNOTAVBL
seet also copy whose PAN No. ("PANNOTAVBL") from Received Sheet. For make you
better understanding I'm upload a excel file (Test.xls) in following url
http://www.freefilehosting.net/download/3c93e

Thanks in advance.


"Montu" wrote:

Hi, as per your advice it's not close my demand.
I just want whenever put date in E7 (letter sheet) the acknowledgement no.
will be copy from received sheet & in B18 (letter sheet) date should be copy
starting date inrespect of sending date (that means letter date & sending
date shoul match) as shown in letter sheet. simultaneously in PANNOTAVBL
seet also copy whose PAN No. ("PANNOTAVBL") from Received Sheet. For make you
better understanding I'm upload a excel file (Test.xls) in following url
http://www.freefilehosting.net/download/test.xls

Thanks in advance.

"Herbert Seidenberg" wrote:

If this is not close to what you want,
mark it up and upload it.
http://www.freefilehosting.net/download/3agj9

You could also create a new workbook and add a query (Data-Import
External Data-New Database Query. Then select Excel Workbook) and
join the 2 tables/worksheets by both Date and PAN reference.
Then add a parameter to your query and link it to a cell in your new
workbook.

Giff