Hi
I am currently working on a project that works like a EPOS system for school in excel.
i have used a vlookup so that the user can enter the product code and the v lookup will then bring up the product information. u can change the qty of the item sold etc, and it adds up a total.
what i want to do that i am stuck with is once that item has been sold i then want to take the amount of that item sold of the stock qty of that item in my lookup table.
any help on how to do this will be great thanks. i just dont know where to start with it.
thanks
Tom
Bookmarks