First off thanks for getting back to me.
I will rework it and take out the merged cells out then I will start debugging if necessary after that . If I do need you after that I will reach out to you thanks again for the direction !

QUOTE=MarvinP;4629612]Hi,

First, get rid of all those Merged Cells. It may look cool but you don't know what cell the data is going to be entered into.

Then look how to debug your code by setting a breakpoint and stepping through it.

http://www.cpearson.com/Excel/DebuggingVBA.aspx

If that doesn't work and you need more, let me know..[/QUOTE]