Excel - Data analysis - Copying several sheets into s/s but one shows #VALUE and can't eradicate

Copper Contributor

I'm analysing the results from an RFP using a macro based s/s 

NO problem with 3 out of 4 of the RFP returns but one of them when copied and pasted using Paste Special - Values Only (as instructed by my manual) the cells calculating the totals all show #VALUE rather than the result

Can anyone help with this please?

 

Thanks

Andrew

 

0 Replies