Need Customization of my Excel sheet.
Budget: $10 – $30 USD
have created stock report. Now, I using dropdown list for "Opening balance", "Inward", "Outward" and "closing balance" in column and put values separately in different columns for all three options.
Now, I want calculate the closing stock at the end of each day. for this, I have to sum values in "Opening Bal." column with sum of values "Inward" column and then subtract the sum of values in "Outward" column of entire day. I have to perform same at the end of the day.
My problem is that is there way or function i put so it calculate closing stock values automatically when i put a drop-down option as "Closing Stock".
And It should only sum the values of "Opening balance", "Inward" and "Outward" before previous "Closing Stock".
Now, I want calculate the closing stock at the end of each day. for this, I have to sum values in "Opening Bal." column with sum of values "Inward" column and then subtract the sum of values in "Outward" column of entire day. I have to perform same at the end of the day.
My problem is that is there way or function i put so it calculate closing stock values automatically when i put a drop-down option as "Closing Stock".
And It should only sum the values of "Opening balance", "Inward" and "Outward" before previous "Closing Stock".