sort and extract text to another excel file

Hi,

i have a large excel file contains about 100,000 rows of data on one column and need to be sorted and filtered to another file with three columns.

The main file contains one column with those data, and i need to extract them to another file as shown below


1.png

i have attached two files for before and after.

There some points if possible to be maintained:

1- Save the extracted result to another excel file at the same path.

2- Save the result file after extracting every 5000 rows to avoid crashing file because of the huge number of data as i mentioned previously, and preferred to add progress bar as this

2.png

and to be saved with name like this sequence: 1-5000 / 5001-10000 / 10001-15000 .....etc.



I'm sorry if i make it long and little bit hard but i appreciate if someone can help or give me a little hint because i'm in a big trouble with that file .


Thanks in Advance

Cheers


Cross Posted link: Here