Hi All,

I'm new on this forum and have been reading members of this site helping others with excel problems. You all are great and want to thank you for your time and help.

Here's my problem, need a macro that would increment the new value I am assigning in the first column by 1 each time the value in the second column changes.

for example i have three rows in column B with the number 10025 and for each row in column A there is a 1. When the number in column B changes to let's say, 10034, the value in column A then changes to 2. When the number changes again in column B to 10043, the value you in column A will change to 3, and so on.

Any ideas or suggestions? My boss wants me to write a macro and I have no idea how to do it as I'm learning excel recently and taking classes. thanks for your help!