Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling in some blanks to a data table
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling Blanks only with ABOVE nonBlanks | Excel Programming | |||
Filling in blanks | Excel Discussion (Misc queries) | |||
Filling in the blanks methods? | Excel Programming | |||
Access - Filling Blanks | Excel Worksheet Functions | |||
Filling in blanks. | Excel Worksheet Functions |