Ravi kumara
New Member
- Joined
- Nov 27, 2014
- Messages
- 19
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>