VBA Insert rows Offset

MCC123

New Member
Joined
Apr 17, 2019
Messages
13
Hi all, I need help figuring out how to insert rows in between other rows. I keep a locomotive periodic maintenance report, I have 3 rows and each row is for each locomotive one underneath the other. I need to be able to insert a row below each piece of equipment. I have a code that will do just that but it only works a few times and then starts inserting rows where I don't need it. I'm very new at this and do not know all the proper terminology. Please see example below. My problem is when hit command button a few times it will only insert new lines below the 601 and 602. I need continuous data therefore I need to keep inserting lines below the 601, 602, 603. Thanks in advance! The Data spans from Column b to column T and rows 14 15 and 16.

Beginning before I hit the command button
[TABLE="width: 1053"]
<tbody>[TR]
[TD="width: 64, bgcolor: #ACB9CA"]601
[/TD]
[TD="width: 77, bgcolor: #ACB9CA"][/TD]
[TD="width: 85, bgcolor: white, align: right"]10/17/2018
[/TD]
[TD="width: 68, align: right"]1/16/2019
[/TD]
[TD="width: 69, align: right"]4/6/2019
[/TD]
[TD="width: 69, bgcolor: white"][/TD]
[TD="width: 75"][/TD]
[TD="width: 80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]4/26/2018
[/TD]
[TD="width: 80, align: right"]4/17/2019
[/TD]
[TD="width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] , align: right"]4/26/2017
[/TD]
[TD="width: 101, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD="width: 73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/17/2018
[/TD]
[TD="width: 75, align: right"]1/16/2019
[/TD]
[TD="width: 68, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/17/2018
[/TD]
[TD="width: 68, align: right"]1/16/2019
[/TD]
[TD="width: 68, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/17/2018
[/TD]
[TD="width: 68, align: right"]1/16/2019
[/TD]
[TD="width: 64, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]4/5/2017
[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"]602
[/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white, align: right"]11/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="align: right"]5/1/2019
[/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]6/6/2018
[/TD]
[TD="align: right"]6/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] , align: right"]6/6/2018
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]4/4/2017
[/TD]
[TD="align: right"]5/1/2019
[/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"]603
[/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white, align: right"]12/5/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="align: right"]6/5/2019
[/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]8/3/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] , align: right"]8/2/2016
[/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/7/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/7/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]4/3/2017
[/TD]
[TD="align: right"]6/5/209

[/TD]
[/TR]
</tbody>[/TABLE]

After I hit the command button
[TABLE="width: 1053"]
<tbody>[TR]
[TD="width: 64, bgcolor: #ACB9CA"]601
[/TD]
[TD="width: 77, bgcolor: #ACB9CA"][/TD]
[TD="width: 85, bgcolor: white, align: right"]10/17/2018
[/TD]
[TD="width: 68, align: right"]1/16/2019
[/TD]
[TD="width: 69, align: right"]4/6/2019
[/TD]
[TD="width: 69, bgcolor: white"][/TD]
[TD="width: 75"][/TD]
[TD="width: 80, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]4/26/2018
[/TD]
[TD="width: 80, align: right"]4/17/2019
[/TD]
[TD="width: 87, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] , align: right"]4/26/2017
[/TD]
[TD="width: 101, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD="width: 73, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/17/2018
[/TD]
[TD="width: 75, align: right"]1/16/2019
[/TD]
[TD="width: 68, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/17/2018
[/TD]
[TD="width: 68, align: right"]1/16/2019
[/TD]
[TD="width: 68, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/17/2018
[/TD]
[TD="width: 68, align: right"]1/16/2019
[/TD]
[TD="width: 64, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]4/5/2017
[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]4/17/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/16/2019
[/TD]
[TD="bgcolor: #8497B0"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/16/2019
[/TD]
[TD="bgcolor: #FFD966"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]1/16/2019
[/TD]
[TD="bgcolor: #FFD966"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] "][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"]602
[/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white, align: right"]11/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="align: right"]5/1/2019
[/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]6/6/2018
[/TD]
[TD="align: right"]6/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] , align: right"]6/6/2018
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]2/5/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]4/4/2017
[/TD]
[TD="align: right"]5/1/2019
[/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]6/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/5/2019
[/TD]
[TD="bgcolor: #8497B0"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/5/2019
[/TD]
[TD="bgcolor: #FFD966"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/5/2019
[/TD]
[TD="bgcolor: #FFD966"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]5/1/2019
[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"]603
[/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white, align: right"]12/5/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="align: right"]6/5/2019
[/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] , align: right"]8/3/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] , align: right"]8/2/2016
[/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]2/7/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/7/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/7/2018
[/TD]
[TD="align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]4/3/2017
[/TD]
[TD="align: right"]6/5/2019
[/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: #ACB9CA"][/TD]
[TD="bgcolor: white"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=C9C9C9]#C9C9C9[/URL] "][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/6/2019
[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EDEDED]#EDEDED[/URL] "][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/6/2019
[/TD]
[TD="bgcolor: #FFD966"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]3/6/2019
[/TD]
[TD="bgcolor: #FFD966"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E7E6E6]#E7E6E6[/URL] , align: right"]6/5/2019
[/TD]
[TD="bgcolor: #D9D9D9"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
I am not able to see what you want.

You said insert Rows.

But normally when you insert a row the new row will be empty.

But that is not the case in your example.

You may be inserting cells but not a row

A row involves the entire row.

Inserting cells and rows are not the same.
 
Upvote 0
In your image 4/17/2019 was first in column 6 but after insert was in column 5
 
Last edited:
Upvote 0
I have a copy paste function in my code because there are certain cells that I need to copy the value in when I insert a new row. I just need help with a code that will insert a row once I hit my command button. This report spans the whole year and at the end of the year It will add or insert a row to each 601 - 602 - 603 - With the code I have it will only work a few times - I need to be able to insert a row to each sub header after the beginning of each year.

This is after I hit the command button 3 times - The 1st time it inserted a row below 601 - 602 - 603 - the 2nd time it inserted another row below the last row added to the 601 - 602 - the 3rd time it inserted rows below just the 601. It needs to be able to insert a row below the last row inserted in each the 601 - 602 - 603
[TABLE="width: 1053"]
<colgroup><col width="64" style="width: 48pt;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="85" style="width: 64pt; mso-width-source: userset; mso-width-alt: 3108;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;"> <col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" span="2"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;" span="2"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2486;" span="4"> <col width="64" style="width: 48pt;" span="2"> <tbody>[TR]
[TD="width: 64, bgcolor: #ACB9CA"]601[/TD]
[TD="width: 77, bgcolor: #ACB9CA"] [/TD]
[TD="width: 85, bgcolor: white"] [/TD]
[TD="width: 68, bgcolor: white"] [/TD]
[TD="width: 69, bgcolor: white"] [/TD]
[TD="width: 69, bgcolor: white"] [/TD]
[TD="width: 75, bgcolor: white"] [/TD]
[TD="width: 80, bgcolor: #C9C9C9"] [/TD]
[TD="width: 80, bgcolor: #C9C9C9"] [/TD]
[TD="width: 87, bgcolor: #EDEDED"] [/TD]
[TD="width: 101, bgcolor: #EDEDED"] [/TD]
[TD="width: 73, bgcolor: #E7E6E6"] [/TD]
[TD="width: 75, bgcolor: #F2F2F2"] [/TD]
[TD="width: 68, bgcolor: #F2F2F2"] [/TD]
[TD="width: 68, bgcolor: #F2F2F2"] [/TD]
[TD="width: 68, bgcolor: #F2F2F2"] [/TD]
[TD="width: 68, bgcolor: #F2F2F2"] [/TD]
[TD="width: 64, bgcolor: #E7E6E6"] [/TD]
[TD="width: 64, bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"]602[/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"]603[/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
[TR]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: #ACB9CA"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: white"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #C9C9C9"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #EDEDED"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #F2F2F2"] [/TD]
[TD="bgcolor: #E7E6E6"] [/TD]
[TD="bgcolor: #D9D9D9"] [/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

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