Quote Originally Posted by SamT View Post
A 18Mb zip file and I have to rename all the files? Open each one and truncate it to five lines, then import each one into Excel, then copy the sheet from each book into one book?

When all I need are the top five lines from each? No thanks.
The 'Collected Data' file is the .CSV files imported into Excel. But, I'm working on cutting the data down.

So, to clarify do you need it in .CSV format or in Excel format? Secondly, should all the data be for the same regno numbers or can it be for any regno numbers? (The first 5 lines aren't always for the same regno numbers. Is that fine?) And finally, if you need CSV files, do you need the original data or the filtered data? The latter is the original but I deleted everything that isn't class=110



Also, I know that you said working with the Excel file wouldn't be possible? But, I just saw this: http://thinketg.com/how-to-return-mu...ch-or-vlookup/ It uses an Array formula. Could we use something similar to search for regno numbers and copy the nearby columns into a separate spreadsheet.


PS: Sorry for the delay in responding. I've been incredibly busy for the last few days. But, hopefully, now I'll have more time to spend on this. And thanks again for bearing with me! And for the help so far!