Hello everyone. I'm back with another 'data manipulation' kind of
question. I'm using Excel 2010 and I have a weekly table similar to
the one that you see in Figure 1 below. The last field, entitled
Location has some blank entries in it and this is the way it comes out
of the system and I have no control over that aspect of it. I want my
code to simply go down the Location column and anywhere it finds a
blank space insert the words NO LOCATION. Please see Figure 2 for what
the end result should look like. Can anyone help me out with the code
that would make this happen? Thank you very much.

Fig 1.

FirstName Lastname EmpID MgrEmpID
Email Location
Alex Anderson aaaa abcxy
Philadelphia
Brooke Brown bbbb aaaa
Philadelphia
Carol Clark cccc aaaa

David Drew dddd aaaa
Philadelphia
Erin Eisley eeee bbbb

Felicia Ford ffff
bbbb Phoenix


Fig 2.

FirstName Lastname EmpID MgrEmpID
Email Location
Alex Anderson aaaa abcxy
Philadelphia
Brooke Brown bbbb aaaa
Philadelphia
Carol Clark cccc aaaa
NO LOCATION
David Drew dddd aaaa
Philadelphia
Erin Eisley eeee bbbb
NO LOCATION
Felicia Ford ffff
bbbb Phoenix