VBA to fill the row

[shiva_reshs]

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

[stnkynts]

I feel like you are a consultant and you just post all your clients problems here for us to solve.

Please Login or Register  to view this content.

[shiva_reshs]

Thanks Stnkynts.

You are partially right.. I am not consultant but employee working in small farm. In my day to day activity I work on many reporting file which is done manually. This forum helped me a lot in learning codes because of which I have made my life easy. I learned but not upto the skill all you guys have. So I try building code first and when I fail I seek your help here.

And I do not post the client problem here, but help my self in day to day file in which I work manually.

And plus, I do contribute as much as I can on queries posted by others here with the best of my knowledge.

If I reaching out asking for help here is wrong, then please let me know.. I will abstain from posting query henceforth.


Anyways, your code works wonderful.. Thanks...
Reps added.

Regards,
Shiva