Actualising

[Adseder]

Hi there, I want to make a actualising list of quantitie for material. I have to manage item quantities, and I want to keeps the list up to date. I am tired of manualy doing the calculation. What a plan on doing is to have the actual quantites in a list, on the first column, called " inventories ". The second column would be the number that I have sold, called " sold ". The third column would be the number that I bought ( which should be added to the first column) and name " bought". The probleme is that, when i do this, I cannot keep a up to date inventorie, because the first column is related to the second, and that if I say that entry of the first column is equal to a number minus the entrie of the second and plus the entrie of the thrid, they are then all related togheter. What I would need is to have the number then calculated to be reported on a independent list, which would no longer be related to the calculation. Let say, A1 entrie is 10, B1 is 3 and C1 is 0.
I should have a number of 7 item left instock. I would want to report this number in a list, which would automaticly update the entrei A1 when I would open my worksheet on the next use. The optimal would be to have a macro who could do a similar thing. Let say a "reset " button, making all entrie on second and third column disapear and first column be updated by the list just made. I have been trying many way, but always get involed in a circular relation between all the cells. Any1 got idea?

[martindwilson]

zzzzzzzzzzzzzzzzzzzzz
how about a mock up workbook and ask specific questions on bits you can't do?

[Adseder]

" how about a mock up workbook and ask specific questions on bits you can't do? "

-What is a mock up workbook ?

[martindwilson]

http://www.thefreedictionary.com/mock-up
an example laid out how you expect to see it with results you'd expect.