I typically sit there for quite a while trying several different combinations of what I think the program will accept. I think the TextToColumns action is a bit too tricky for me to tackle on my own right now. I have set several other little stupid things while awaiting the next lesson. (Auto fit columns, add the view filter.. Easy things ). The record macro button helps, naturally. I record something, see what it does, and then apply. I did the same with the texttocolumns / formatting, but cant seem to get it to do what I want. Tried to apply your lessons and what he code recording showed me, but I guess I'm missing something. Oh well , not important at the moment- we will get there. Grouping and formatting take up the most time of this export anyhow. Either one can occur first - I just had some time to kill.

Thanks again. And , [un]fortunately I dont work on Friday 's but will pop on anyway if I see you post.