VBA EXCEL Populate blank cells in column B on sheet 2 from repeating list on sheet 1 until column B is complete : i decided to make a picture with small example to explain it easier. col D should be populated with names from col A repeating until each ID has a name. i have absolutely no idea how to loop it to make it work.  mind boggling.  i have been searching google for hours so i am now asking for help.  thanks so much.

[![example][1]][1]


  [1]: http://i.stack.imgur.com/qU4C9.png