Autofill data from above cell while Grouping

Vijaya Kanthi

New Member
Joined
Jul 27, 2018
Messages
14
Hello,

I have a report which is generated in grouping type.... data will be something like this :

Original Source:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]Code
[/TD]
[TD]Date
[/TD]
[TD]Size
[/TD]
[TD]Sample
[/TD]
[TD]Pass
[/TD]
[TD]Fail
[/TD]
[TD]%
[/TD]
[/TR]
[TR]
[TD]Code1
[/TD]
[TD]01.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]5
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[TD]1
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]03.08.2018
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]60
[/TD]
[/TR]
[TR]
[TD]Code2
[/TD]
[TD]01.08.2018
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]02.08.2018
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD]9
[/TD]
[TD]1
[/TD]
[TD]90
[/TD]
[/TR]
[TR]
[TD]Code 3
[/TD]
[TD]01.078.2018
[/TD]
[TD]30
[/TD]
[TD]15
[/TD]
[TD]10
[/TD]
[TD]5
[/TD]
[TD]66.6
[/TD]
[/TR]
</tbody>[/TABLE]
The report is grouped at Code1,code 2, code 3

Now I want to create a Macro which can re-create the Macro in the below format....


[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01.08.2018
[/TD]
[TD]02.08.2018
[/TD]
[TD]03.08.2018
[/TD]
[TD]04.08.2018
[/TD]
[TD]05.08.2018
[/TD]
[/TR]
[TR]
[TD]jj
[/TD]
[TD]kk
[/TD]
[TD]Code 1
[/TD]
[TD]100
[/TD]
[TD]80
[/TD]
[TD]60
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ss
[/TD]
[TD]yy
[/TD]
[TD]Code 2
[/TD]
[TD]100
[/TD]
[TD]90
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ll
[/TD]
[TD]mm
[/TD]
[TD]Code 3
[/TD]
[TD]66.6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]rr
[/TD]
[TD]ee
[/TD]
[TD]Code 4
[/TD]
[TD]100
[/TD]
[TD]98
[/TD]
[TD]90
[/TD]
[TD]96
[/TD]
[TD]95
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


There are 151 codes and the dates has to change according to the Week... If the macro can ask for which week /days it has to take from the orginial source... that would help a lot

kindly advice

Help is much appreciated

Regards,
K
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top