Hi There,
I have big excel files with 600 000+ lines, I have to split those 600 000 in to 30 000 lines each base on the invoice number sourced in second tab. Selected 30k I have to past into new file.
For now I am counting lines on the invoice and sum the up till I reach around 30 000k (each invoice has different number of lines).
On tab One I have for example F/2022/01/29 and on the second tab I mark all lines with this reference.
I know that full operation would be a long piece but could you help me with macro which will count lines as close as possible to 30k then highlight with one color then start again mark it with second color till it reach the end?
Best Regards,
Waldo
I have big excel files with 600 000+ lines, I have to split those 600 000 in to 30 000 lines each base on the invoice number sourced in second tab. Selected 30k I have to past into new file.
For now I am counting lines on the invoice and sum the up till I reach around 30 000k (each invoice has different number of lines).
On tab One I have for example F/2022/01/29 and on the second tab I mark all lines with this reference.
I know that full operation would be a long piece but could you help me with macro which will count lines as close as possible to 30k then highlight with one color then start again mark it with second color till it reach the end?
Best Regards,
Waldo