Hi All
I need a macro to repeat the last value in the column A depending on the Number of values present in the Column B.
Ex:
ColA Colb
Dad 56
Mom 78
Son 67
89
78
So the value "SON" should be repeated until the 78 in the column B.
Thanks in Advance
I need a macro to repeat the last value in the column A depending on the Number of values present in the Column B.
Ex:
ColA Colb
Dad 56
Mom 78
Son 67
89
78
So the value "SON" should be repeated until the 78 in the column B.
Thanks in Advance