circular reference

[Sasa Stankovic]

Hi,
I feel stupid but I just can't get any idea how to avoid circular reference.
I have table (first sheet) where I am supposed to put in quantities and on
the other sheet i have table with warehouse infmation. What I want is to
reduce amount from warehouse by number enterd in table on first sheet so i
can always know how many quantites I have in warehouse!
Any idea?
Thanks in advance!

 

[Sandy Mann]

What you are trying to do is not possible, or rather, is not practicable
using formulas, you would need to use VBA. Would that be an acceptable
option?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sasa Stankovic]

Hi,
Well, i do know solution with VBA but i was thinking about formulas and I
couldn't find any solution. I always end with circular reference.
But, thanxs for trying! I will solve the problem with VBA and everything
will be OK.
I would be even more happy with Access but it is not OK with my friends who
should use application.
Thanks one more time!

sasa stankovic

 

[Spiky]

What have you tried? It ought to be possible (and not too difficult)
to make the warehouse sheet a running total without circular formulas.
Depending on how the table is set up, perhaps DSUM or SUMPRODUCT could
be used in the warehouse sheet. And keep any references to the
warehouse sheet out of the table (first sheet) to avoid circular
issues.

I have a feeling the problem is more in the design of the sheets than
in finding the right formula.