Add and subtract from another sheet

  • Hello, I have a workbook with two sheets Sheet 1- Oldstock 2021-2022 : It contains warehouse information Sheet 2- Transaction we are selling & returning items stated Question 1: About the information we got from the first article We have two processes: the sale (Sale) and the return (retrieval) and the quantity sold or returned After putting the quantity sold, I want to make a confirmation in order to transfer NEWSTOCK to Quantity in stock on the first sheet. Question 2: 2- How to add the current date automatically each time I add a new line I put it now () but how is it written automatically The file is attached. Thank you.

  • Here's an example that contains a layout to store transactions, i.e. stock in and out and a master sheet that shows current tock levels updated by formulas.

  • Hello, I have a workbook with two sheets Sheet 1- Oldstock 2021-2022 : It contains warehouse information Sheet 2- Transaction we are selling & returning items stated Question 1: About the information we got from the first article We have two processes: the sale (Sale) and the return (retrieval) and the quantity sold or returned After putting the quantity sold, I want to make a confirmation in order to transfer NEWSTOCK to Quantity in stock on the first sheet. Question 2: 2- How to add the current date automatically each time I add a new line I put it now () but how is it written automatically The file is attached. Thank you.

    You got it figured out yet or do you need additional help?

  • Here's an example that contains a layout to store transactions, i.e. stock in and out and a master sheet that shows current tock levels updated by formulas.

    Thank you very much, I will try the same in my work & get back to you.
    You are a life saver roy.

  • The formulas are fairly easy to adapt. Note I use Tables which are much better for this purpose.


    Overview of Excel Tables


    Post back if you are unsure of anything.

  • Here's another solution in case anyone is interested later: