I need a macro that can loop, since the number of rows will always be different. I want to delete the repetitive entires in the first column (i.e. the second B and C). Then, I want to format it so that the row for A is white, B is grey, C is white, and D is grey, and so on alternating like that.
Can anybody give me advice on this? It would be greatly appreciated.