------ Register to get rid of these "In Post" ads! ------


Hi Simon ,

I have a workbook in Excell with 2 sheets ,
first is invoice sheet , second is a product sheet but i also want to use it as a stock management system .
So for every invoice made in sheet 1 , the quantity should degrade as new invoices are made .

The problem i have on this moment is , that with my current formula`s , stock is working , BUT if i delete the data on the invoice sheet , logically the stock turns back to it`s old state .
So i guess i need some kind of button to tell that he should change stock as invoice 01 is ready , press that button , stock changes , and then it should remember everything , as soon as the invoice data is being deleted again to make invoice nr 02
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/members-excel-vba-programming/168762-how-decrease-inventory-relation-invoices.html#post608218

Could you help me out ?
Maybe i can send you my file ...

Thanks in advance .

Greetings , Youri from Belgium .

------ Register to get rid of these "In Post" ads! ------


Hi Youri,
Thread Title

__________________
Cheers -

------ Register to get rid of these "In Post" ads! ------


Attachments.

__________________
Regards,
Simon Lloyd
Excel Chat

------ Register to get rid of these "In Post" ads! ------


In my opinion this will prove a bit too involved for a Forum question. I have set up systems for this but it took a lot of coding time

__________________
Hope that helps, RoyUK
For tips & examples visit my web site

------ Register to get rid of these "In Post" ads! ------


Thank you Pecoflyer for Thread Title adjustment .
Roy , thank you for your opinion : i can imagine this kind of coding will be difficult to explain on forum .
I hope you can show me the way somehow .

I have no experience with VBA coding , but i am sure , that`s exactly what i gonna need for my solution , no formula`s here will help i guess .

I will try to upload my file .

Greetings and Thankx

------------------------------ posted before receiving a reply after 6 minutes of original post ------------------------------

So here is the workbook .

You will see a first sheet , the incoive sheet ,
there you can select from dropdown , the products , and price comes automatically with it . Just set a quantity , and voila , you have your first invoice

On the second sheet , you see the list with products , where the dropdown makes use off . There next to it , i would like my stock column to work
You`ll have a colomn for stock on the 01jan 2010 , and through the year some delivery`s ... etc

The problem is that , when you delete the data from your invoice to make another invoice , nr 02 , logically the formula does his work and everything comes back to what is was .
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/members-excel-vba-programming/168762-how-decrease-inventory-relation-invoices.html#post608420
So i need a button , that says , adjust stock , on the invoice sheet ,
and then it should remember that , and so on , i can make my new invoice
with deleting all data again .

I don`t want to make a new sheet for every invoice .

Thank you , for any help !
Youri

Attached Files

Spa ProductenStock.xlsx (91.8 KB, 3 views)

------ Register to get rid of these "In Post" ads! ------


Your product list is not set up to be used an excel database. The information should be set out in a table format with headers & no empty columns & rows.
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/members-excel-vba-programming/168762-how-decrease-inventory-relation-invoices.html#post608440

To do this properly,you need code to generate the invoice,forms to add customers,stock etc. Quite a big project very similar to one that I am working on now,so I know how much work will be involved

__________________
Hope that helps, RoyUK
For tips & examples visit my web site