i wana macro code help me in subtract daily sales from my stock daily
when i put the daily sales codes in sheet 1 and hit enter
it subtract these codes from stock in sheet 2
thank you...
i wana macro code help me in subtract daily sales from my stock daily
when i put the daily sales codes in sheet 1 and hit enter
it subtract these codes from stock in sheet 2
thank you...
Hello, would you be able to answer a couple of questions for me?
Is your sales sheet on sheet 1 a list of all the codes just like the one in sheet 2, and you just put a +/-1 in the cell next to it if you sold it that day? Or do you write the codes in when you sell them and want the macro to have to match the code to the one in sheet2?
Do you mean you would like the macro to delete the code from sheet 2, or to subtract 1 from the existing stock of that code?
i mean when i write code in sheet 1 or i scan it by scanner it subtract 1 from the quantity of its stock "the same code and the same size " in sheet 2... if i can subtract it once i scan it it will be very helpful
thanks alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks