Question 1:
It sounds like you want to confirm the updating of your old stock sheet (but only for sales).
Problem you have is, you are updating your new stock by a formula using your quantity sold and quantity in stock. Then when you update the Old stock with a confirmation in VBA, your quantity in stock is updated (again by formula) which means your New stock is updated again.
I would solve this by getting rid of the formula in your New Stock column and update it with VBA (see below)
Question 2:
I have put the date in automatically for you in your code too. Don't forget to format the cells as the date format you wanr.
PS. If you want to update Your Old stock regardless (which makes more sense to me - but I don't count) then you need to take your confirmation outside of that If statement.
Bookmarks