Hi All,
I have monthly input excel with stock data.
1. One excel Input as initial Stock Details (one time input data). This is the values captured in columns 1, 2 and 3.
2. Another input excel with Addition and Delete values. These are in column 4 and 5, corresponding to column 1 and 2.
3. Each month stock will be added and deleted. This data will be provided on monthly basis to populate in the table below.
4. The calculated value (Final stock) will be the Stock for next month.
5. For Feb month the Final Stock of Jan should be captured in Stock.
Kindly see the output for the month January as below:
The calculations are : C+D = Stock + Addition, Final Stock = Stock + Addition - Delete.
The Final Stock is calculated in Chart. Please guide me with the best way to store and use it for the next month's input.
| Country |
Company |
Stock |
Addition |
Delete |
C+D |
Final Stock |
| SG |
A |
24 |
7 |
16 |
31 |
15 |
| B |
12 |
4 |
4 |
16 |
12 |
| C |
10 |
1 |
2 |
11 |
9 |
| Totals |
46 |
6 |
22 |
52 |
30 |
| IND |
A |
5 |
1 |
0 |
6 |
6 |
| Totals |
5 |
1 |
0 |
6 |
6 |
| US |
A |
1 |
0 |
0 |
1 |
1 |
| B |
2 |
3 |
0 |
5 |
5 |
| Totals |
3 |
3 |
0 |
6 |
6 |
| MY |
A |
45 |
3 |
2 |
48 |
46 |
| Totals |
45 |
3 |
2 |
48 |
46 |
| UK |
A |
3 |
0 |
0 |
3 |
3 |
| Totals |
3 |
0 |
0 |
3 |
3 |
| Totals |
|
102 |
13 |
24 |
115 |
91 |
