Bypass Circular Reference?

[noobdisaster]

I track employee training hours on an individual basis. I have one cel
that is dedicated to their total hours. As of now, if an employee ha
had a training session, say .25 hours, I manually add the .25 to thei
total. Let's say their total before the session was 25.50 hours. The
an employee receives new training of .25 hours, so, obviously, thei
new total will be 25.75 hours. If an employee has had training, I hav
a column that I log an "X" in to indicate they have participate. Thi
"X" is transposed to another sheet to provide an overview of ou
companies training. Here is my problem. I would like to be able t
enter the new training to be added to the total training with the "X
and have a total returned to the original column. This creates
circular reference. Any ideas how I can accomplish this

+-------------------------------------------------------------------
|Filename: Circular Ref.JPG
|Download: http://www.excelforum.com/attachment.php?postid=3935
+-------------------------------------------------------------------

 

[noobdisaster]

Sorry to bump this, but is this not possible?

 

[JE McGimpsey]

Bumping generally leads to my killing posts. I haven't gone back to find
the question you posted (for some reason it didn't catch my attention,
and I've marked it as read), but it's very rare that a question simply
goes unanswered in these groups. If nobody's replied, it may be for one
of several reasons:

1) You didn't wait long enough - some questions get answered in minutes,
some in hours, but generally you should wait at least 12-24 hours before
you assume it's slipped through the cracks.

2) You may have attached a file. Most regulars don't open attached
files, nor do they download files from FTP sites (though that's greatly
preferred to attachments). The potential for virii just isn't worth the
risk. In addition, most people who post files are lazy with their
descriptions. While the purpose of a spreadsheet may be intuitively
obvious to them, more often than not I've found that I can't tell what
the poster really wants if I open a file. Those who take the time to
spell out the problem in a plain text message often find that the
process helps them go a long way toward answering their own questions.

3) You may not have clearly stated your question. This is the most
frequent reason posts go unanswered. What may be crystal clear to you
might be mud to everyone else. Try approaching it as if you were
describing the problem to someone who has no understanding of what
you're trying to do (because that's what you're doing). If you think
your question may have been unclear, you need to reword it, give
specific examples, etc., rather than just "bumping" it.

4) The question may not have a simple answer - often the questions that
get answered in a few minutes are those that have a very simple answer.
Answers that are more complex may wait for someone to have time to work
through it. Remember that everyone here's a volunteer.

5) Occasionally people post with an attitude - very rarely there's a
post from someone with a chip on their shoulder that goes unanswered
because nobody want's to help a jerk. That's *really* unusual.

See

http://cpearson.com/excel/newposte.htm

for tips on using these groups effectively.


noobdisaster