Spreadsheet: 185486d1349727135-macro-to-fill-in-missing-blanks-with-data-in-a-column-example
Sheet: Before Macro

Code | Busines Unit | Sub Code | Amount | PM | Finish Date
1234 | Head Office | 1 | 211.55 | [NAME] | 2012-01-01 00:00:00
 |  | 2 | 452.55 | [NAME] | 2012-05-10 00:00:00
 |  | 3 | 556.56 | [NAME] | 2012-03-19 00:00:00
2345 | East Office | 2 | 4500.54 | [NAME] | 2012-03-20 00:00:00
 |  | 4 | 450.56 | Nick | 2012-03-21 00:00:00
 |  | 6 | 859.55 | [NAME] | 2012-03-22 00:00:00
 |  | 7 | 85.65 | [NAME] | 2012-03-23 00:00:00
 |  | 3 | 45.8 | [NAME] | 2012-03-24 00:00:00
 |  | 23 | 1234.58 | [NAME] | 2012-03-25 00:00:00
 |  | 5 | 12568.99 | [NAME] | 2012-03-26 00:00:00
 |  | 45 | 1568.94 | [NAME] | 2012-03-27 00:00:00
4567 | North Office | 65 | 4582.68 | Julie | 2012-03-20 00:00:00
 |  | 34 | 4256.98 | Collette | 2012-03-21 00:00:00
1254 | West Office | 45 | 452.68 | [NAME] | 2012-03-22 00:00:00
 |  | 344 | 99.88 | [NAME] | 2012-03-23 00:00:00
 |  | 765 | 44.66 | [NAME] | 2011-12-02 00:00:00
 |  | 5645 | 7589.99 | Majella | 2011-12-03 00:00:00
 |  | 434 | 458.59 | Maria | 2011-12-04 00:00:00
 |  | 34 | 472.88 | Helen | 2011-12-05 00:00:00
 |  | 343 | 10112.58 | [NAME] | 2011-12-06 00:00:00
 |  | 3434 | 1028.98 | [NAME] | 2011-12-07 00:00:00
 |  | 34 | 1536.98 | [NAME] | 2011-12-08 00:00:00
 |  | 565 | 1582.36 | [NAME] | 2011-12-09 00:00:00
6456 | South Office | 434 | 8542.65 | Nick | 2011-12-10 00:00:00
 |  | 343 | 5483.56 | [NAME] | 2011-12-11 00:00:00
 |  | 764 | 2548.55 | [NAME] | 2011-12-12 00:00:00
6785 | Cardiff | 311 | 4589.55 | [NAME] | 2012-03-22 00:00:00
5464 | Newport | 23 | 6584.26 | Nick | 2012-03-23 00:00:00
 |  | 545 | 45872.55 | [NAME] | 2011-12-02 00:00:00
 |  | 767 | 4582.68 | [NAME] | 2011-12-03 00:00:00
 |  | 989 | 4528.66 | [NAME] | 2010-10-03 00:00:00
 |  | 675 | 5423.66 | [NAME] | 2010-10-01 00:00:00
 |  | 343 | 77500.55 | [NAME] | 2010-10-02 00:00:00
 |  | 353 | 4470.55 | [NAME] | 2010-10-03 00:00:00
 |  | 232 | 452.36 | [NAME] | 2010-10-04 00:00:00
8885 | Swansea | 243 | 4525.88 | [NAME] | 2010-10-05 00:00:00
 |  | 656 | 1111.25 | Julie | 2010-10-06 00:00:00
 |  | 868 | 2225.58 | Collette | 2010-10-07 00:00:00
 |  | 756 | 5896.36 | [NAME] | 2010-10-08 00:00:00
 |  | 454 | 7524.22 | [NAME] | 2010-10-09 00:00:00
2344 | London | 34 | 12536.44 | [NAME] | 2010-10-10 00:00:00
 |  | 452 | 85.69 | Majella | 2010-10-05 00:00:00
 |  | 232 | 5425.69 | Maria | 2010-10-06 00:00:00
 |  | 545 | 55.55 | Helen | 2012-05-23 00:00:00
 |  | 767 | 7859.66 | [NAME] | 2012-05-24 00:00:00
 |  | 454 | 45283.69 | [NAME] | 2012-05-25 00:00:00
 |  | 234 | 4528.66 | [NAME] | 2012-05-26 00:00:00
 |  | 767 | 458.96 | [NAME] | 2011-06-06 00:00:00
 |  | 686 | 7854.96 | Majella | 2012-05-20 00:00:00
3434 | Blackwood | 856 | 4523.68 | Maria | 2012-05-21 00:00:00
 |  | 565 | 78223.64 | Helen | 2012-05-22 00:00:00
 |  | 878 | 85423.36 | [NAME] | 2012-05-23 00:00:00
4344 | Bristol | 573 | 4542.11 | [NAME] | 2012-05-24 00:00:00
 |  | 343 | 4523.65 | Nick | 2012-05-25 00:00:00
 |  | 464 | 45.26 | [NAME] | 2012-05-26 00:00:00
 |  | 464 | 789.66 | [NAME] | 2011-06-06 00:00:00
5555 | Bath | 335 | 4525.366 | [NAME] | 2011-06-07 00:00:00
 |  | 467 | 111.25 | [NAME] | 2011-06-08 00:00:00
 |  | 886 | 859.36 | Majella | 2011-06-09 00:00:00
 |  | 632 | 4582.66 | Maria | 2011-06-10 00:00:00
 |  | 436 | 7859.65 | Helen | 2011-06-11 00:00:00
 |  | 353 | 7452.66 | [NAME] | 2011-06-12 00:00:00
 |  | 686 | 7526.99 | [NAME] | 2011-06-13 00:00:00