Thank you for your help, with it have been able to get it working the way I wanted it to. You are correct on the date issue. The data imported into the worksheet was not a date data type. When that was corrected it worked perfectly.

Thanks Again