John,

I input the code and tried running it, but to no avail no information transferred to the other sheets. In being discrete about information, I had to change the composition from the original excel file that I posted. The header contains the following: A:1 - Portfolio Manager; B:1 - Business Name; C:1 - Loan ID; D:1 - Maturity Date; E:1 - Principal Balance. Make note that I did change the rcell range from the original E2:E to D2:D. Is there something that I need to change?