Help Needed For Excel

6 posts · originally from https://geek.digit.in/community/threads/help-needed-for-excel.31771/

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.

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

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

tuxfan said:
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,

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

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