<div>
put autofilter on the sheet - in data, filtering, then filter column three, go to custom and create the custom filter..<br />
<br />
then once filtered, copy and past the records into a new sheet.
</div>


put autofilter on the sheet - in data, filtering, then filter column three, go to custom and create the custom filter..

then once filtered, copy and past the records into a new sheet.

EE-DataFiltering.xlsx

<div>
beaten to it with longer post :P
</div>


<div>
<div class="content wysiwyg-content">
I have never worked with excel before simplequestion but just need to get this done ASAP.<br />
There is a sheet which has 40000 plus records<br />
col1 &nbsp; col2 &nbsp; col3 &nbsp; col4 col5<br />
<br />
<br />
I need to pull out data (rows)from this sheet into a new one such that value of col3 is in (val1,val2,val3,val4,val5,<wbr />val6,val6,<wbr />val8,val9,<wbr />val10) &nbsp;I should be getting approx 20000 records. How do I do this in excel. <br />
<br />
YRKS
</div>
</div>


I have never worked with excel before simplequestion but just need to get this done ASAP.
There is a sheet which has 40000 plus records
col1   col2   col3   col4 col5


I need to pull out data (rows)from this sheet into a new one such that value of col3 is in (val1,val2,val3,val4,val5,val6,val6,val8,val9,val10)  I should be getting approx 20000 records. How do I do this in excel. 

YRKS

Simple excel report

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.