FWIW the data is salvaged from an old database  lost following a hard
drive failure over a year ago now. Scooting around for a floppy to
backup some current work  I found some Excel workbooks containing data
that had obviously come from the lost database - the data in them is
very useful to me.

I love the efficiency of your macro  and I hope to learn  from it.
Thanks again,