So to start I need to get this conversion making the credit identification number the same as the invoice number with a 9 in front of it working soon as possible.
For each BizName in Returns
Loop thru the Credit BizName cells and if Credit BizName = Return BizName Then if Credit BizName Cell.offset (to Date) = Return Date, then Return Invoice Number = "9" & Left(Credit BizName.offset (to Invoice), n) & Return Invoice Number