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.
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.
test-0-fr-m.xlsm
drive.google.com