Splitting Row Data

5h1v

Board Regular
Joined
Oct 11, 2012
Messages
69
Hey,

Currently this pulls the data in one row

Code:
[COLOR=#333333][FONT=Tahoma][I]
Ary = Application.Index(wb2.Sheets(4).Range("A8:U17").Value, Evaluate("row(1:10)"), Array(1, 3, 4, 7, 13, 14, 15, 16, 17, 18, 19, 20, 21)) Ws.Range("A" & L).Resize(10).Value = wb2.Sheets(4).Range("D3").Value
Ws.Range("B" & L).Resize(10).Value = wb2.Sheets(4).Range("G3").Value
Ws.Range("C" & L).Resize(10).Value = wb2.Sheets(4).Range("A6").Value
Ws.Range("D" & L).Resize(10, 13).Value = Ary
L = L + 10
[/I][/FONT]
[/COLOR]

This pulls data into rows A-N
I want all the data repeated on rows A-H then what is in I on the first row, the second would be A-H + J then A-H +K all the way to A-H + N.

I hope that makes sense.

Is there an easy way I could do this?
 
Last edited:

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
I hope that makes sense.
It doesn't to me and given that your thread has been looked at over 50 times I suspect others are finding the same.
Perhaps you could try again to spell it out more clearly and also give a small set of dummy sample data and expected results?
 
Upvote 0
Thanks I will try;

[TABLE]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[TH]K[/TH]
[TH]L[/TH]
[TH]M[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Item No.[/TD]
[TD]ITEM NAME[/TD]
[TD]Type[/TD]
[TD]SRN[/TD]
[TD]Supplier[/TD]
[TD]Supplier Code[/TD]
[TD]Placement[/TD]
[TD]COLOURWAY 1[/TD]
[TD]COLOURWAY 2[/TD]
[TD]COLOURWAY 3[/TD]
[TD]COLOURWAY 4[/TD]
[TD]COLOURWAY 5[/TD]
[TD]COLOURWAY 6[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]NAVY[/TD]
[TD]JADE GREEN[/TD]
[TD]ROSE TAUPE[/TD]
[TD]RASPBERRY RED[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]BLACK STANDARD[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2618[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]3933[/TD]
[TD]Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]ASH TEAL[/TD]
[TD]BLUSH PINK[/TD]
[TD]SMOKEY GREY[/TD]
[TD]CITRUS ORANGE[/TD]
[TD]OBSIDIAN GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]3933[/TD]
[TD]Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]3933[/TD]
[TD]Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]3924[/TD]
[TD]C legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]BURGUNDY RED[/TD]
[TD]SPRINT BLUE[/TD]
[TD]ROSE TAUPE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]3924[/TD]
[TD]C legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]3924[/TD]
[TD]C legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]BLUSH PINK[/TD]
[TD]CITRUS ORANGE[/TD]
[TD]SMOKEY GREY[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]RASPBERRY RED[/TD]
[TD]SPRINT BLUE[/TD]
[TD]OBSIDIAN GREEN[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER]
[/CENTER]


This is the data that I have, I want to then split this out by colourway so that the columns A-G are repeated for each supplier code (F) and then the colour is added at the end H-M

I hope that makes more sense.
 
Upvote 0
So what would the expected results look like? I expect the first 10-12 rows should do to give the idea?
 
Upvote 0
Sure, the above should look like this;

[TABLE]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]1[/TD]
[TD]Item No.[/TD]
[TD]ITEM NAME[/TD]
[TD]Type[/TD]
[TD]SRN[/TD]
[TD]Supplier[/TD]
[TD]Supplier Code[/TD]
[TD]Placement[/TD]
[TD]Colourway[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]NAVY[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]JADE GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]ROSE TAUPE[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]RASPBERRY RED[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK STANDARD[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]ASH TEAL[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLUSH PINK[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SMOKEY GREY[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]CITRUS ORANGE[/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]OBSIDIAN GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]42[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]43[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]45[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BURGUNDY RED[/TD]
[/TR]
[TR]
[TD="align: center"]46[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SPRINT BLUE[/TD]
[/TR]
[TR]
[TD="align: center"]47[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]ROSE TAUPE[/TD]
[/TR]
[TR]
[TD="align: center"]48[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]49[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]51[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]52[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]53[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]54[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]55[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]56[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]57[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLUSH PINK[/TD]
[/TR]
[TR]
[TD="align: center"]58[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]CITRUS ORANGE[/TD]
[/TR]
[TR]
[TD="align: center"]59[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SMOKEY GREY[/TD]
[/TR]
[TR]
[TD="align: center"]60[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]61[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]62[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]63[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]64[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]65[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]66[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]67[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]68[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]69[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]RASPBERRY RED[/TD]
[/TR]
[TR]
[TD="align: center"]70[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SPRINT BLUE[/TD]
[/TR]
[TR]
[TD="align: center"]71[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]OBSIDIAN GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]72[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]73[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]74[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]75[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]76[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]77[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]78[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]79[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]
[/B][/COLOR][/CENTER][TABLE="width: 85%"]
<tbody></tbody>[/TABLE]



Thanks for the help
 
Upvote 0
There seems to be an issue with the results in column D, both about the values returned
a) eg the last row of your results says SRN2168-M but that looks like it actually comes from column F
b) The results are prefixed with SRN. Is that required? I haven't done so in this code but it could be done if required.

This code puts the results below the original data.

Test in a copy of your workbook.

Rich (BB code):
Sub RearrangeData()
  Dim a As Variant, b As Variant
  Dim i As Long, j As Long, k As Long, c As Long, uba2 As Long
  
  a = Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(, Cells(1, Columns.Count).End(xlToLeft).Column).Value
  uba2 = UBound(a, 2)
  ReDim b(1 To UBound(a) * (uba2 - 7), 1 To 8)
  For i = 1 To UBound(a)
    For j = 8 To uba2
      If Len(a(i, j)) > 0 Then
        k = k + 1
        For c = 1 To 7
          b(k, c) = a(i, c)
        Next c
        b(k, 8) = a(i, j)
      End If
    Next j
  Next i
  With Range("A" & Rows.Count).End(xlUp).Offset(3).Resize(, 8)
    .Value = Range("A1:H1").Value
    .Cells(1, 8).Value = "Colourway"
    .Offset(1).Resize(k).Value = b
  End With
End Sub
 
Upvote 0
If i wanted to expand this so that I could include up to column P, how would I do that?
 
Upvote 0

Forum statistics

Threads
1,224,816
Messages
6,181,141
Members
453,021
Latest member
Justyna P

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