Trace precedent was the first thing I tried to use, but it didn't work. So I
was looking for alternatives.

"Shane Devenshire" wrote:

Hi,

I forgot to ask - you mention Trace Precedents in your title but you don't
address it in the body of the post - how does this come into play in your
question.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"zen" wrote:

I have to enter various figures of work load volume and hourly rates in
various worksheets, at the end I have to run the macro to calculate the
billing amount. The cell which gives me the billing amount is named & I dont
see any formula written there, can I just see the value in formula bar?
Problem is that the one who developed this file had left & secondly our
nature of business is changing, we just want to see how billing amount is
worked out. Any help will be appreciated.