I have a large file over 55,000 lines that has been giving me trouble when i attmept to copy down a complex formula on all of the rows. I want to separate the file into more managable pieces. Mabye 5,000 lines each. The only problem is that I dont want to arbitrarily separate the file. It has groupings by employee number. How can I make the file separate but not break up in the middle of a batch of the same employee number.
Employee Number. Name, Amount
Employee Number. Name, Amount