Glaswegian

Is everything in just one worksheet? You might want to consider splitting your data into several worksheets. If nothing else, it will make the whole thing easier to work with. In fact, I would also consider creating several workbooks, perhaps using the alphabet as break points, e.g. A-E, F-J etc etc.