Macro to Count the number of Rows between a text value that occurs mutliple times

Hi,

I have been giving the task of sorting through a .CSV file that has a lot of raw data (over 350k lines) and need to be able to find the number of rows / lines of an invoice that sales people have invoiced.

So as an example :

863200
863200
863200
359907
TOTAL FO
863200
863200
863200
TOTAL FO
361268
361268
361268
TOTAL FO

I need to be able to count how many rows / cells are between each occurrence of "TOTAL FO" and have the value (the number of rows/ cells)added to a column in another worksheet.

Thank you.

So the Total for Each employee number is next to the email number in a separate worksheet.

Colunn A Column C (In Another worksheet) Column D (In The same worksheet as Column C)

863200 TOTAL FOR 102 3
863200 TOTAL FOR 111 3
863200
TOTAL FOR 102
361268
361268
361268
TOTAL FOR 111
602627
TOTAL FOR 910

Basically so I can then convert the numbers into a graph.