VBA Excel 2013 - Count data rows on single sheet, divide by 3 , color band rows.

[DoodlesMama]

I am working on a daily report that is split between three people because it is so large, around 7-8k rows of data. I need to do two things.

1. Count number of rows and split into three equal parts.

2. Each part will color band only the cell in column A for each user when data changes.

**Each section will be colored according to user and banding will alternate with no color. (Dee=Blue, Jenn=Green, Ray=Purple)

Column A contains a unit ID and the same ID can be on multiple rows.
i.e.
Unit ID
TD1236 - no color
TD1255 - Blue
TD1255 - Blue
TD1258 - no color
TD1265 - Blue
TD1265 - Blue
TD1265 - Blue
TD1265 - Blue
TD1265 - Blue
TD1266 - no color
TD1335 - Blue
TD1344 - no color
TD1349 - Green
TD1364 - no color
TD1373 - Green
TD1385 - no color
TD1388 - Green
TD1423 - no color
TD1432 - Green
TD1432 - Green
TD1443 - no color
TD1444 - Green
TD1477 - no color
TD1535 - Purple
TD1541 - no color
TD1553 - Purple
TD1583 - no color
TD1598 - Purple
TD1623 - no color
TD1641 - Purple
TD1665 - no color
TD1666 - Purple
TD1723 - no color

Any help will be greatly appreciated

[walruseggman]

Please Login or Register  to view this content.