Ethen5155
03-13-2019, 04:18 AM
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
https://www.excelforum.com/attachments/excel-programming-vba-macros/615269d1552474933-sort-and-extract-text-to-another-excel-file-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
https://www.excelforum.com/attachments/excel-programming-vba-macros/615273d1552475439-sort-and-extract-text-to-another-excel-file-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 https://www.excelforum.com/images/smilies/frown.gif.
Thanks in Advance
Cheers
Cross Posted link: Here (https://www.excelforum.com/excel-programming-vba-macros/1268214-sort-and-extract-text-to-another-excel-file.html#post5082133)
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
https://www.excelforum.com/attachments/excel-programming-vba-macros/615269d1552474933-sort-and-extract-text-to-another-excel-file-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
https://www.excelforum.com/attachments/excel-programming-vba-macros/615273d1552475439-sort-and-extract-text-to-another-excel-file-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 https://www.excelforum.com/images/smilies/frown.gif.
Thanks in Advance
Cheers
Cross Posted link: Here (https://www.excelforum.com/excel-programming-vba-macros/1268214-sort-and-extract-text-to-another-excel-file.html#post5082133)