extracting data of ROW by conditional check of one column

[Ravi kumara]

I am using excel 2007 and 2013 in windows xp and 7, From the below sample data in sheet1 of workbook1- If "C1" is present in column G1 - G10 , then all the data correspanding to that ROW containg "C1" should be written in other sheet of new workbook. Is it possible if so solve my problem.
	Data in sheet1 of workbook1
	A	B	C	D	E	F	G
	332	07/11/2014	CDPO	24/10/2014	950	Office shifting	C1
	333	07/11/2014	DC	31/10/2014	-	Jeep KA-35 G-45	KHR
	334	07/11/2014	AEE, QC	17/10/2014	-	work regarding	ASO
	335	07/11/2014	Prinicpal, ITI	29/10/2014	-	Training programme	C1
	336	07/11/2014	AC	29/10/2014	-	tri-month report	C1
	337	07/11/2014	DC	23/10/2014	887	Fees payment	ASO
	338	07/11/2014	EE,PWD	31/10/2014	1083	building safty	ASO
	339	07/11/2014	EE,PWD	31/10/2014	1072	construction of building	KHR
	340	07/11/2014	EE,PWD	31/10/2014	1082	work regarding	KHR
	341	07/11/2014	EE,PWD	31/10/2014	1077	work regarding	KHR
	Result in sheet1 of workbook2
	332	07/11/2014	CDPO	24/10/2014	950	Office shifting
	335	07/11/2014	Prinicpal, ITI	29/10/2014	-	Training programme
	336	07/11/2014	AC	29/10/2014	-	tri-month report

<tbody>
</tbody>

 

[Ravi kumara]

Sir,the above code is working amazingly. thank u sir, for solving my all issues.</pre>

 

[Peter_SSs]

Sir,the above code is working amazingly. thank u sir, for solving my all issues.

Glad we got there in the end.