Visual Basic Macro creation

I need help in completing a macro using visual basic. The macro takes data from and excel spreadsheet and places it into another application. I have data in multiple rows in the excel spreadsheet. What I need is to be able to have this macro choose the data in one row, move it to the appropriate application, and then continue and choose data from the next row and to continue until it reaches a * or other symbol at which time the macro stops processing.

I would appreciate any help you could provide in getting this working for me.

Thanks,

Record macro from the toolbar and then use that coding to achive you task