Crietria & Extraction

[qsami]

Hi All,

Thanks for reading this.
I have a workbook with data and I want to extract this data to another workbook in 4 different worksheets applying 4 different conditions.
What I am looking to establish is all the rows that meet condition specified on the end of the each row should be pulled to other workbook and then i would have four sheets in workbook 2 pulling different information from workbook 1.

Book2
	A	B	C	D	E	F	G	H
1	Company	Refno.	Person	Code	Nature	StartDate	EndDate	Status
2	A	1	AA	1AA	New	01/03/2006	31/12/2009	Verified
3	B	2	BB	2BB	Old	05/07/2006	31/12/2007	Verified
4	C	3	CC	3CC	New	26/08/2006	01/01/2009	Notverified
5	D	4	DD	4DD	Old	27/08/2006	15/09/2008	Notverified
6
7	Condition1	New-Verfied
8	Condition2	Old-Verified
9	Condition3	New-NotVerfied
10	Condition4	Old-NotVerified
Sheet1

 

[Krishnakumar]

See: http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/build_query_1.html

HTH

 

[qsami]

Hi,

I really appreciate your guidance and will try to effectively use it but Cant use MS Query because of the simple reason that we do not have this software loaded on our machines and we can not do it because it does not comply with company policies.

 

[Krishnakumar]

Make the query via Data > Get External Data > New Database query..

HTH

 

[qsami]

completely unaware how it works can you please tell me a step by step process

 

[Krishnakumar]

Hi,

See: http://www.mrexcel.com/board2/viewtopic.php?t=214339

http://www.mrexcel.com/board2/viewtopic.php?t=217377

Also read the article in Tushar's site.

 

[qsami]

Hi Kris,

Its saying that it cant create tables can you think f any possible reason as the files are not read only

 

[qsami]

Complete message is Since the database is read only you can not create tables continue? I am at stage when i need to add tables when i can see none.