I need to be able to to the same thing that is outlined in a previously
posted question however I must select and copy more then just the first
column of data. I need to copy columns a-e and then have the original
columns (a-e) copied and the variable data (f-...) transposed into
another sheet.

Please Help!!

Example:
A B C D E F G H I
123 more info more info Brown Black Red Purple
456 other stuff other stuff Orange White Yellow


I need it to look like this
A B C D E F
123 more info more info Brown
123 more info more info Black
123 more info more info Red
123 more info more info Purple
456 other stuff other stuff Orange
456 other stuff other stuff White
456 other stuff other stuff Yellow


http://groups.google.com/group/micro...0 6ec53b0030f