Having hard time getting formatting correct

Alright Excel Forum users and Gurus!

I have attached the sample workbook I have been working with for all my codes. I am trying to create a calculated column that takes Serial Rcvd - Serial Shipped = Devices Owed. Just like on the other worksheets in the workbook. However, the code seems to get stuck in the loop and also does not even do calculation.

This is the code I currently have for the calculations...

Please Login or Register  to view this content.

I also what to change the destination of the pivot table from the Master Data Collection worksheet to the Summary Report Worksheet.

This is the code I have for the pivot table

Please Login or Register  to view this content.

Let me know how to resolve these issues.

Also...does anyone know how I can create a code that will import an attachment from Outlook into this workbook?



Thanks!