VBA to AutoFill down dynamic columns

[eorydc]

I'm looking for a VBA to AutoFill down the contents in column B. It's difficult to describe what I am looking to do, but essentially I want to AutoFill the contents of cell Bn to the next row with text and continue to the end of the sheet. Is this possible in one Macro? Attached is a sample of the raw data. Thank you.

[millz]

If I understand what you mean.... Filter column B for blanks. Then in the first blank cell, should be B3, enter =B2 and drag to the last row.

[AB33]

No need for macro!
There is an excel built-in function:
Highlight column B
CRTL plus G
click special
tick blank
go to B3= and copy B2 then
No enter, but CRTL plus enter fill in down.

[eorydc]

This doesn't work in full. Not all the data in Column B should be the same. In the attached sample, B2:B24 are the same, B25:B38 are the same, B39:B70 are the same, etc.

[millz]

So maybe elaborate more on what you want to achieve, possibly post a new sample workbook with at least 50-100 rows of the desired results in.

[eorydc]

Good idea. Here is a sample of what the intention would be. Hopefully this helps. Thanks again.

[millz]

That is exactly what AB33's and my solution is doing - just different approach. Did you follow the steps correctly?

Also, remember to highlight entire column B, copy, and paste special as values.

[eorydc]

Maybe not. What do I do after clicking OK on the Go To Special window?

[AB33]

CRTL plus G will take you to a mini-window called Go to, there you click special

[eorydc]

I understand the following steps:
Highlight column B
CRTL plus G
click special
tick blank
click OK

I'm not sure what to do next. Thank you.

[AB33]

Another one

http://www.youtube.com/watch?v=9TDcVOKbm34

[AB33]

It is easier to follow this link

http://www.youtube.com/watch?v=CpYnLnhTgOo

[eorydc]

Got it. Thank you.
Highlight column B
CRTL plus G
click special
tick blank
click OK
type "=B2"
press CTL+Enter