VBA: Autofill blank cells between ones with entries

Hello there,

I have the following dataset:

City	Neighborhood
City 1	Some place
City 1	Another one
City 1	Anywhere
City 1
City 1
City 2
City 2
City 2
City 2
City 3	Everywhere
City 3
City 3
City 3

It contains one column that sometimes has data, sometimes it doesn't. It depends on the City column.

I'd like to know how could I autofill the blank cells with two possible values:

1. Other
-OR-
2. Doesn't apply

Other when the cell belongs to a City that DOES have neighborhoods
Doesn't apply when the cell belongs to a City that DOES NOT have neighborhood.

The end result looking like this:

City	Neighborhood
City 1	Some place
City 1	Another one
City 1	Anywhere
City 1	Other
City 1	Other
City 2	Doesn't Apply
City 2	Doesn't Apply
City 2	Doesn't Apply
City 2	Doesn't Apply
City 3	Everywhere
City 3	Other
City 3	Other
City 3	Other

Any advise?

I have attached the original table. It does not contain any sensitive data. The columns related to this issue are colored in yellow.

Thank you very much for your help!

This can't be done without VBA - shall I move the thread for you?

Oh, Okay AliGW. Thank you!

Here's one way...

Please Login or Register  to view this content.

Glad i could help...Tx for rep...please mark thread as solved...