Hi,

I have Column with numerical series.

Like,
Column A Column B

B6 1
B7
B8
B9 2
B10
B11 3
B12
B13
B14
B15 4

B7 and b8 is blank above, so want VBA to automatically put preceding value as "1" in B7 and B8.
Same way B10 which is blank, have the preceding value 2 to update there..
Like wise do for all below. Update preceding value.

How can do this with VBA?

Thanks,
Shiva