Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-725007%22%20slang%3D%22en-US%22%3EExcel%20-%20Data%20analysis%20-%20Copying%20several%20sheets%20into%20s%2Fs%20but%20one%20shows%20%23VALUE%20and%20can't%20eradicate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-725007%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20analysing%20the%20results%20from%20an%20RFP%20using%20a%20macro%20based%20s%2Fs%26nbsp%3B%3C%2FP%3E%3CP%3ENO%20problem%20with%203%20out%20of%204%20of%20the%20RFP%20returns%20but%20one%20of%20them%20when%20copied%20and%20pasted%20using%20Paste%20Special%20-%20Values%20Only%20(as%20instructed%20by%20my%20manual)%20the%20cells%20calculating%20the%20totals%20all%20show%20%23VALUE%20rather%20than%20the%20result%3C%2FP%3E%3CP%3ECan%20anyone%20help%20with%20this%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EAndrew%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-725007%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

 

Related Conversations
Help with counting formula
AL789 in Excel on
0 Replies
Excel hangs up during execution of any operation
Rohit_Agrawal in Excel on
0 Replies
how to create custom number format permanently
iman89 in Excel on
0 Replies
drop-down list vs if-then vs ??
thetis in Excel on
0 Replies
RTD
adriangray in Excel on
0 Replies
Convert Days to whole months
SPC123 in Excel on
2 Replies