thanks and apologies Sean, I will try to simplify my code and comeback here shortly.

Thank you.

I met with the business and re-organized their requirement. All good. Thank you all for responding.

Apologies.

Thanks guys. I will keep you all posted.

Yes, the I am talking about columns. I have to help the user get the data split into multiple(3 in this case) spread sheets like a horizontal split from the...

uh oooh. Any suggestions on how to Import this flat file into Excel?