Do Until VBA Loop

[csigman]

Hello,

I'm trying to create a Do Until code in VBA that will populate a certain value in column A until a criteria is met in column B, after which it will populate a second value. I think this should be a relatively quick Do Until code, but unsure how to create it.

Below is a quick example.

Starting at row 6, populate column A with F2 until B="Entity_ID". After that, populate column A with F3 until the end of the data set.

 

[Joe4]

Welcome to the Board!

Seems like this could be done pretty easily without VBA, just using a formula.
Put this in cell A6 and copy down:

=OFFSET(F$1,COUNTIF(B$5:B6,"Entity_ID"),0)

 

[csigman]

Welcome to the Board!

Seems like this could be done pretty easily without VBA, just using a formula.
Put this in cell A6 and copy down:

=OFFSET(F$1,COUNTIF(B$5:B6,"Entity_ID"),0)

Thank you!!

 

[Joe4]

You are welcome.
Glad I was able to thelp!

 

[csigman]

he Board!

Seems like this could be done pretty easily without VBA, just using a formula.
Put this in cell A6 and copy down:

=OFFSET(F$1,COUNTIF(B$5:B6,"Entity_ID"),0)

Hello - I now have a situation where I need to update the state name to a new name every time I reach the "entity_ID" cell. There could be up to 8 different states that need to be populated down column A. Is this achievable with the formula you provided?

 

[Joe4]

Hello - I now have a situation where I need to update the state name to a new name every time I reach the "entity_ID" cell. There could be up to 8 different states that need to be populated down column A. Is this achievable with the formula you provided?

I am confused. Is that what my formula already does?
How is this new question any different than your original?
This should work regardless of how many states you have.

 

[csigman]

I am confused. Is that what my formula already does?
How is this new question any different than your original?
This should work regardless of how many states you have.

Apologies - it is working for me. thank you!