in reply to Using a Range to Parse a file and pull out Data?
What is stopping you from re-sorting by date and the magic number? Finding the first magic number after a date change is simple and fast.