i have a report that is getting to wide in excel to be manageable. it is a "punch-list" of sorts that lists known issues with various stores. it lists 10 issues per location, and each issue has 4 columns associated with it, so I am now 40+ columns wide.
if anyone could help with a macro that could rearrange this report, it would save me a lot of copy/paste time.
additional notes: when the report is exported to excel, it is the only active sheet in the workbook. i guess the code would need to insert sheet 2 and paste the data there
thanks a lot for any help you can give
It basically looks like this:
i would like to get it to look like this to be readable on the screen and where it can print nicely
if anyone could help with a macro that could rearrange this report, it would save me a lot of copy/paste time.
additional notes: when the report is exported to excel, it is the only active sheet in the workbook. i guess the code would need to insert sheet 2 and paste the data there
thanks a lot for any help you can give
It basically looks like this:
HTML:
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
storeCityStatetypedateissue #1quantity #1resolution #1ordered #1issue #2quantity #2resolution #2ordered #2REPEATING ALL THE WAY TO #10issue #10quantity #10resolution #10ordered #10aknoxvilletnlarge1/1/12 bhoustontxsmall1/2/12 cmiamiflmedium1/3/12 dromegasmall1/4/12i would like to get it to look like this to be readable on the screen and where it can print nicely
HTML:
table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}
storeCityStatetypedateissuequantityresolutionorderedaknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 aknoxvilletnlarge1/1/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12 bhoustontxsmall1/2/12
