I am trying to write a macro to split up the information on a cell, which
contains a dash between a name and a title. I want to put the name in one
cell and the title in another. When I create the macro, it only recognizes
the actual cell that I have used to record the demo, it does not advance down
the spreadsheet to the next cell.

Do you know how I make it go down a cell at the end and go to the next
record/row?

Thanks