the book is listed at http://www.oreilly.com/catalog/excelhks/chapter/

It is hack #16 and covers several pages -- a little too involved to list here.

"Jamesmor" wrote:

Pete,

I have a similiar problem, but don't actually have Excel Hacks, can you give
me an idea how to get started with this?

"Pete" wrote:

I have tried the example in "Excell Hacks" but it is too complicated to
extend over more than 2 columns. I would like to extend to 10 columns. A
VBA solution would be OK if necessary.