The description of your problem leaves a lot to be desired,
but it is understandable if you know the answer, you want to
snake the columns, see
http://www.mvps.org/dmcritchie/excel....htm#snakecols
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"pcor" wrote in message ...
Ihave data in col A & B
Theamount of data can be only 10 lines or could be 100 lines
lets assume I have 99 entries in col A & B
I would like the macro to copy lines 33 to 66 to start at d1 & d1
then copy the remiander (ie line 67 to 69) to start at f1 & g1