Thank you both,
I guess the non elegant solutions get it then. I must be dreaming but I was sure that I made it do it about a year ago. Makes me wonder what else I thought I'd done but didn't?..
I remember now what I did, just putting it here incase someone wants to use the same technique. By the way this is not nearly as clever as the above methods...
Set up the first row,
as in my earlier post
cell a1, reference 'sheet2!a1'
then highlight this cell and the two empty rows beneath. Then grab the bottom right corner of the selection and drag down far enough to cover all of your data. This should have selected every third row with two blank rows between. Then just sort the data ascending, all of the blank rows get sorted to the bottom and my data seems sequencial.
Last edited by Jimmy Macintosh; 7th Dec 2007 at 06:53.
Reason: Revelation from the past!