Have you seen the Excel / MapPoint examples at
Working With Excel and MapPoint - MP2K Magazine ?
Also, the Help file programming examples are awesome.
If / when you get stuck after that, please post your code and/or attach your spreadsheet, from there I think we can jump in more easily to help.
Eric