Hi Paul,
I guess I will have to just copy from one line and paste to another and then go back and delete. I do have the information linked to another spreadsheet, a calendar that needs to be updated constantly.
Thanks anyway.