I am trying to create a macro. I need to copy and paste the table from sheet1 into sheet2. The first table is in sheet1 and the second table will be in sheet2. The data should look like the table in sheet2.
Column A will remain constant. Column B will remain constant until all the data points for each time period have been pasted into separate rows. Column C will also remain constant until all data points for each time period have been posted. Column D will remain constant. The time period will be pasted under a column labeled "Time" and continue to repeat according to the values for the corresponding time period. All the values will be posted under a column lableled "Signed Data" and the value for each corresponding month will be pasted in separate rows.
Any help on this would be much appreciated.
Sheet1
[TABLE="Class: Grid"]
<colgroup><col><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Comp_Code[/TD]
[TD]Profit Center[/TD]
[TD]Cost Element[/TD]
[TD]SPECIALID[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]Feb-18[/TD]
[TD="align: right"]Mar-18[/TD]
[TD="align: right"]Apr-18[/TD]
[TD="align: right"]May-18[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2
[TABLE="Class: Grid"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Comp_Code[/TD]
[TD]Profit Center[/TD]
[TD]Cost Element[/TD]
[TD]SPECIALID[/TD]
[TD]TIME[/TD]
[TD]SIGNEDDATA[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
</tbody>[/TABLE]
Column A will remain constant. Column B will remain constant until all the data points for each time period have been pasted into separate rows. Column C will also remain constant until all data points for each time period have been posted. Column D will remain constant. The time period will be pasted under a column labeled "Time" and continue to repeat according to the values for the corresponding time period. All the values will be posted under a column lableled "Signed Data" and the value for each corresponding month will be pasted in separate rows.
Any help on this would be much appreciated.
Sheet1
[TABLE="Class: Grid"]
<colgroup><col><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD]Comp_Code[/TD]
[TD]Profit Center[/TD]
[TD]Cost Element[/TD]
[TD]SPECIALID[/TD]
[TD="align: right"]Jan-18[/TD]
[TD="align: right"]Feb-18[/TD]
[TD="align: right"]Mar-18[/TD]
[TD="align: right"]Apr-18[/TD]
[TD="align: right"]May-18[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2
[TABLE="Class: Grid"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Comp_Code[/TD]
[TD]Profit Center[/TD]
[TD]Cost Element[/TD]
[TD]SPECIALID[/TD]
[TD]TIME[/TD]
[TD]SIGNEDDATA[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Other/Divest[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Cost Of Sales[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]0.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Fuel and Power[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.01[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.02[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.03[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.04[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
[TR]
[TD]WH00[/TD]
[TD]Pipes[/TD]
[TD]Oil (Loss)/Gain[/TD]
[TD]SHELLSHARE[/TD]
[TD]2018.05[/TD]
[TD="align: right"]10.00[/TD]
[/TR]
</tbody>[/TABLE]