big problem..

[KisH \(Tihomir\)]

Hello, again,
So, I have Sheet1,Sheet2 and Sheet3, here is the structure:
Sheet1
A1 - listbox(it pulls items(text) from Sheet3(A1,A2) )
B1 - number(it is pulled with VLOOKUP from Sheet3 and it is coressponding to
each item which is selected in A1(listbox) )
Sheet2
A1 - listbox(it pulls items(text) from Sheet3(A1,A2) )
B1 - i need manually enter some number
Sheet3
A1 - item1
B1 - 3
A2 - item2
B2 - 4

Now,when I choose in Sheet2 from listbox(A1) "item1", and enter number "1"
in B1 , formula automaticly needs to update
information in Sheet3 for item1( A1) to number 2 (B1) , basicly formula
needs to do "B1(sheet3) minus B1(sheet2) = 2" and that number 2 must write
in Sheet3 B1.

Can you understand what I need?
Thank you.

 

[KisH \(Tihomir\)]

Hello, again,
So, I have Sheet1,Sheet2 and Sheet3, here is the structure:
Sheet1
A1 - listbox(it pulls items(text) from Sheet3(A1,A2) )
B1 - number(it is pulled with VLOOKUP from Sheet3 and it is coressponding
to each item which is selected in A1(listbox) )
Sheet2
A1 - listbox(it pulls items(text) from Sheet3(A1,A2) )
B1 - i need manually enter some number
Sheet3
A1 - item1
B1 - 3
A2 - item2
B2 - 4

Now,when I choose in Sheet2 from listbox(A1) "item1", and enter number "1"
in B1 , formula automaticly needs to update
information in Sheet3 for item1( A1) to number 2 (B1) , basicly formula
needs to do "B1(sheet3) minus B1(sheet2) = 2" and that number 2 must write
in Sheet3 B1.

Can you understand what I need?
Thank you.

anyone can help?

 

[Sandy Mann]

I think that the problem is that you are asking for a circular calculation.
I have always found circular calculations to be troublesome. You cold do it
with VBA but even then if you try to automate it then you end up in the
situation whereby if the used changes the number in Sheet 2 before changing
the Item then the wrong number will be changed in Sheet 3. You could still
use VBA but it will have to be manually run.

--
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

 

[KisH \(Tihomir\)]

I think that the problem is that you are asking for a circular calculation.
I have always found circular calculations to be troublesome. You cold do
it with VBA but even then if you try to automate it then you end up in the
situation whereby if the used changes the number in Sheet 2 before changing
the Item then the wrong number will be changed in Sheet 3. You could still
use VBA but it will have to be manually run.

Problem was solved yesterday .
Thank you anyway.