Here is a link to some code for importing from an Excel workbook:
www.erlandsendata.no/.../index.php

In terms of trolling through the active rows,
www.vba-programmer.com/.../...Cells_with_Data.html will
help you.

Please bookmark both sites. Many more useful examples in there. Since this is
for training purposes, you might want to write this yourself, and make sure you
understand what the code does.