Excel Macro

I need an excel macro thatcopies an Invoice number down a column. When the value in a 2nd column changes, then the Invoice number increments by 1. I currently do this with conditional formatting, but need it automated.