Again as I said in the first post. If anyone is willing to help me create a macro that will make the credit identification number match the invoice identification number from that day and put a 9 in front of it I would be very happy. If I must I would be able to pay a small fee if that is what is required. I am not able to figure this out. I have tried but still have not been able to get it to work correctly. Just a macro I can run on the raw data before I copy and paste it into my xlsm files would be perfect.