I need to write a macro to fill Column C based on Column B. Column A has all
rows filled with text. Code needs to start reading at B2 (Row 1 contains my
headers) and enter a number trend down in Column C until it reads the next
number in Column B, then start the trend again and continue until the last
line of Column A. Column B is already filled out. I just need code to fill
Column C. Is this possible? I don't know where to begin with the code.
Your help would be greatly appreciated. I am using Excel 2002.
My spreadsheet example below.
Column B Column C
1 1
2
3
2 1
2
3 1
2
3