banker
06-23-2008, 10:12 PM
Hi all
Please refer to the attachment provided... I need some code that will rearrange this data (in a way transpose it) by a click of a button. The outcome would be like the outcome on the outcome tab.
Basically, the code needs to start from column F5 all the way to the end..
It needs to copy this row description in cell F5 and place it in a new sheet in A3
In cell B3 in the new sheet, the code needs to copy the column Heading in I4 on this sheet (231640) and copy it in this new sheet.
In cell C4, The value of the intersect needs is to be copied here.
Similarly, this process needs to repeat itself for each Column heading from I4 to the end of the sheet for the same row description in cell f5
This is outlined in the outcomes tab as to what the code needs to generate..
It needs to do it for each row description from cell f5 to the bottom of the last record.
The data will always start from Column F4 downwards.. and columns I onwards.. columns G and H are excluded. Also Rows 1,2, and 3 will be excluded..
At all times there will only be 3 columns that is generated by the code from the source data..
Many thanks to all that can offer their solution to this problem
Please refer to the attachment provided... I need some code that will rearrange this data (in a way transpose it) by a click of a button. The outcome would be like the outcome on the outcome tab.
Basically, the code needs to start from column F5 all the way to the end..
It needs to copy this row description in cell F5 and place it in a new sheet in A3
In cell B3 in the new sheet, the code needs to copy the column Heading in I4 on this sheet (231640) and copy it in this new sheet.
In cell C4, The value of the intersect needs is to be copied here.
Similarly, this process needs to repeat itself for each Column heading from I4 to the end of the sheet for the same row description in cell f5
This is outlined in the outcomes tab as to what the code needs to generate..
It needs to do it for each row description from cell f5 to the bottom of the last record.
The data will always start from Column F4 downwards.. and columns I onwards.. columns G and H are excluded. Also Rows 1,2, and 3 will be excluded..
At all times there will only be 3 columns that is generated by the code from the source data..
Many thanks to all that can offer their solution to this problem