Hello Amanda,I am sorry to hear you have problems with the macro.
The error message could be triggered by following:1. The "custodian download" workbook is open in a different instance of Excel application.
To fix that make sure you do not hold Shift key while double-clicking the files or simply open all files from same Excel window using File -> Open.
2. There was a change in the cells the macro uses to identify the workbook.
The "identification" cells and expected content are (without quotes):
B1 = "Fees Taken Report"
C6 = "Account Number"
H6 = "Average Fee"Please verify the above. If you are in doubt, please send me the file (trough http://www.wikisend.com and post the FileID here; set the file "lifetime" to 1 day by clicking on Properties).Regards,Tom