Colour cells when value changes

[davidman1]

I have a list of employees in Excel with data (attached), how can I get VBA to get the data in Sheet1 to be presented as it is in Sheet2?

The first row should be coloured in, then all rows for that person should be coloured in the same, when it goes to the next person it should be blank.


Any ideas?

Edit: the data is already sorted into alphabetical order before it is put onto this sheet.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[davidman1]

Maybe:

Please Login or Register  to view this content.

Thanks, but how would I change this so it can run in a normal sub? There are 6 sheets like this, which I would like to keep hidden if possible (although activating them one at a time could work).

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[sktneer]

Please try this to see if this is what you are trying to achieve.

Please Login or Register  to view this content.

Refer to the attached and click the button 'Click Here" to run the code in order to get the desired output.