Thanks in advance for anyone's suggestions. I will give feedback on any suggested solutions.
Why am I getting a "Compile error: Invalid Qualifier" on "xlDataField" within the line:
'Add item to the Data Field to either Count or Sum. In this Case Sum
With...