Help Needed For Excel

[saigalp]

I have a file in Excel containing around 22000 items. Out of which I want to select and export around 3000 items to another file. Please guide me as to what is the easiest and fastest method to do this.
Thanks in advance.

 

[tuxfan]

How is the sheet formatted? What does it contain? Give more details.

 

[sms_solver]

If 22000 items is in a column then u can make use of Advanced Filter option of Excel

 

[saigalp]

How is the sheet formatted? What does it contain? Give more details.

The sheet has 3 rows, A- contains Part no., B- contains Description, C- contains
The Price. I want to select the required part nos. and export to another file.
Awaiting response,

 

[rakeshishere]

Copy the items whichever u want and open another file and use PASTE SPECIAL FEATURE

 

[Ramakrishnan]

use the autofilter feature. You can use it to filter in any combination and permutation and get the data you want easily. data>filter>Autofilter