I'm having trouble with getting some percentages to reference from one worksheet to the next. The percentages in the original sheet will not appear correctly in the next sheet as references. The only thing that shows up is #VALUE. The percentages are calculated from the partial sums of different number sets that constitue the overall total. What might I be doing wrong?
Not providing a sheet for us to look at.What might I be doing wrong?
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Point out the problem areas.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Or at the very least tell us exactly how you are referring to them from the other sheet. A straight cell link should not return #VALUE unless the linked cell contains a #VALUE error.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks