Hi,
Slightly different method of doing it, but if your Spreadsheet is just on one tab, why not move the data into an Access database? Access can handle larger record sets far easier (there's a 65K limit on cells in excel).
You can then use MS Query to display just the information you need in an Excel format.
Just a thought...
Ad