Macro not calculating correctly

I have two tabs in my worksheet Dashboard and Details.. in the Dashboard I have rows that look like:
AMC 78
ANG 152

These are all links to the Details tab. So if you click on say 78, it takes you to the Details tab and filters on the col1 (ie. AMC), and gives you all AMC items....

What should happen is that the TOTAL (ie. 78 or 152) in the SUmmary should correspond to the DETAIL tab (ie. 78 lines of AMC data, or 152 lines of ANG data)...

Need more info let me know... I gotta get this thing out....

My Code looks like the below:

Please Login or Register  to view this content.