Summary sheet to create multiple worksheets

Hello - I'm new to the forum and know next to nothing about VBA. Browsing through the threads here, I found a code that could help me at my job. However when I run it I receive an error message - Run-time error 13: Type mismatch.

Ultimately the macro does what I want it to do and can live with the error, but please help me to understand what went wrong.

Problems:
Besides debugging the code, how do I also get it to skip accounts that have the "Amount" field blank? If there is no amount to pay, I don't want the macro to create a new worksheet unnecessarily and to skip to the next account that might.

Please Login or Register  to view this content.