Help with Automated Calculations with Copy and Paste Macro

[beantownmt]

Hi
I have a Spreadsheet that has the ability to have data entered manually with a trigger point and all my calcualtions work great.
Instead of manually entering my data now. I set up a macro to import larger amounts of data.
The probelm I'm having now I can Not get the automatic calculations to work?
I'm using the following code to copy and past from Sheet1 to JeffsTransp
This Code Works

Please Login or Register  to view this content.

I Can Not Get This Calculation to Work.? it works when the data is manually entered to trigger the trigger point.

Please Login or Register  to view this content.

What is the best way to automate the Calculations with the Copy and Paste Code?

any Help that can be offered would be greatly appreciated