how can i auto fill the blankcell with a value till the next blank..den auto
fill again with another values..mean in this case i wan the value "A" to fill
up all the blank cell below it and stop on top of the value"B" den auto fill
with "b" values to nxt blank n cont...

eg..

col a col b
A 1
2
3
B 2
3
C 4