Hi Lyle,
To read about installing and using macros see
Getting Started with Macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm

I have such a reference at the top of most of my pages with macros,
I'll fix that omission.

Since you mention 9 pages, the specific area you want to read the most is
Attempting to Snake columns using Excel (#snakecols)
http://www.mvps.org/dmcritchie/excel....htm#snakecols
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Montrose Lyle" wrote ...
Thanks for the answer. It can be done, but it isn't easy. McRitchie's
instructions run to nine pages, plus lots of links if you are not familiar