Hi There,
Greeting! I am trying to create the macro for fill the series at the end for every sku. But unfortunately not succeed. Please check the example below
Before
[TABLE="width: 215"]
sku
[/td][td][/td][/tr][tr][td]Grand Count
[/td]
[TD="align: right"]1515[/TD]
LEPR04 Count
[/td]
[TD="align: right"]7[/TD]
LEPR04
[/td][td]B0080ED9O2
[/td][/tr][tr][td]LEPR04
[/td][td]B00BP4FYCE
[/td][/tr][tr][td]LEPR04
[/td][td]B00MXBDBA0
[/td][/tr][tr][td]LEPR04
[/td][td]B00AXBNG84
[/td][/tr][tr][td]LEPR04
[/td][td]B00AKHC2EA
[/td][/tr][tr][td]LEPR04
[/td][td]B00N7JIDGY
[/td][/tr][tr][td]LEPR04
[/td][td]B00J4VT520
[/td][/tr][tr][td]DRG272 Count
[/td]
[TD="align: right"]4[/TD]
DRG272
[/td]
[TD="align: right"]6040546514[/TD]
DRG272
[/td][td]B00MXBDDPI
[/td][/tr][tr][td]DRG272
[/td][td]B00D5SDECA
[/td][/tr][tr][td]DRG272
[/td][td]B00L927OWK
[/td][/tr][tr][td]DRG273 Count
[/td]
[TD="align: right"]1[/TD]
DRG273
[/td][td]B00AUXLXAI
[/td][/tr][tr][td]DRG275 Count
[/td]
[TD="align: right"]4[/TD]
DRG275
[/td][td]B00ANL92TG
[/td][/tr][tr][td]DRG275
[/td][td]B00MXBDGAU
[/td][/tr][tr][td]DRG275
[/td][td]B00AKH9Y8W
[/td][/tr][tr][td]DRG275
[/td][td]B00JNALXCM
[/td][/tr]
[/TABLE]
After
[TABLE="width: 339"]
[tr][td]sku
[/td][td][/td][td][/td][td][/td][/tr][tr][td]Grand Count
[/td]
[TD="align: right"]1515[/TD]
LEPR04 Count
[/td]
[TD="align: right"]7[/TD]
|
[/td][td][/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B0080ED9O2[/TD]
LEPR04
[/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B00BP4FYCE[/TD]
LEPR04_1
[/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B00MXBDBA0[/TD]
LEPR04_2
[/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B00AXBNG84[/TD]
LEPR04_3
[/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B00AKHC2EA[/TD]
LEPR04_4
[/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B00N7JIDGY[/TD]
LEPR04_5
[/td][/tr][tr][td]LEPR04
[/td]
[TD="colspan: 2"]B00J4VT520[/TD]
LEPR04_6
[/td][/tr][tr][td]DRG272 Count
[/td]
[TD="align: right"]4[/TD]
|
[/td][td][/td][/tr][tr][td]DRG272
[/td]
[TD="align: right"]6.04E+09[/TD]
DRG272
[/td][/tr][tr][td]DRG272
[/td]
[TD="colspan: 2"]B00MXBDDPI[/TD]
DRG272_1
[/td][/tr][tr][td]DRG272
[/td]
[TD="colspan: 2"]B00D5SDECA[/TD]
DRG272_2
[/td][/tr][tr][td]DRG272
[/td]
[TD="colspan: 2"]B00L927OWK[/TD]
DRG272_3
[/td][/tr][tr][td]DRG273 Count
[/td]
[TD="align: right"]1[/TD]
|
[/td][td][/td][/tr][tr][td]DRG273
[/td]
[TD="colspan: 2"]B00AUXLXAI[/TD]
DRG273
[/td][/tr][tr][td]DRG275 Count
[/td]
[TD="align: right"]4[/TD]
|
[/td][td][/td][/tr][tr][td]DRG275
[/td]
[TD="colspan: 2"]B00ANL92TG[/TD]
DRG275
[/td][/tr][tr][td]DRG275
[/td]
[TD="colspan: 2"]B00MXBDGAU[/TD]
DRG275_1
[/td][/tr][tr][td]DRG275
[/td]
[TD="colspan: 2"]B00AKH9Y8W[/TD]
DRG275_2
[/td][/tr][tr][td]DRG275
[/td]
[TD="colspan: 2"]B00JNALXCM[/TD]
DRG275_3
[/td][/tr]
[/TABLE]
Kindly let me know if any solutionforum.ozgrid.com/index.php?attachment/63091/forum.ozgrid.com/index.php?attachment/63091/ for it. Right now I am adding it manually.
Regards,
James