Hello,
I have an excel file that changes every day. It has a header row with the names of the columns in it. It has columns A through Y and the number of rows is different every day.
I need to take the first row, insert a blank row under it, copy the data from the row above it from column Q through Y into column A through E on the line below it. Then I need it to repeat until it gets to the last row.
I have attached the example of the sheet that I am starting with and what I need it to look like after the macro works. Please help, I am dying here.
I have excel for mac 2011
Thanks
I basically need to convert this
Names of columns in first row
A B C D E F G H I J K L M N O P Q R S T Y
A B C D E F G H I J K L M N O P Q R S T Y
A B C D E F G H I J K L M N O P Q R S T Y
A B C D E F G H I J K L M N O P Q R S T Y
to this
Names of columns in first row
A B C D E F G H I J K L M N O P
Q R S T Y
A B C D E F G H I J K L M N O P
Q R S T Y
A B C D E F G H I J K L M N O P
Q R S T Y
A B C D E F G H I J K L M N O P
Q R S T Y
Bookmarks