Offsetting row using VBA

[karthuappu]

in the image ill need to offset the rows using an if condition (if lastrow -5= Black,leave as is else offset by 1) and so on until the last row, i Cant figure out how to write the code as the positions keep changing( a new table is added each week with the same labels)

https://imgur.com/a/8m5Mj2F

The Link has a better desc and images.
Thanks
[FONT=&quot]






[/FONT]

 

[My Aswer Is This]

If you would provide written details of what you want I may be able to help.
Just posting a image for us to see and instructions in the image does not help me.
I hardly ever click on links posted in this forum.