This might get a little bit misleading however I will try and be as clear as possible....
This below table represents Sheet 1.
<tbody>
</tbody>
Sheet 2 is linked to sheet 1 via Line number and the total stock needs to match up to stock on this table, but by a sum of each line.
<tbody>
</tbody>
In Sheet 2. I want to have an additional row called Total Stock which will automatically calculate the stock value of the line number. So Line number 4003 will bring back a value of 50+100+100.
this will then be used to do a true or false check on sheet 1 (does stock match?)
Any suggestions are welcome.
Thanks.
This below table represents Sheet 1.
Line Number | Stock |
4001 | 10 |
4002 | 50 |
4003 | 250 |
<tbody>
</tbody>
Sheet 2 is linked to sheet 1 via Line number and the total stock needs to match up to stock on this table, but by a sum of each line.
Line Number | Batch | Stock |
4001 | 75-B | 10 |
4002 | 77-B | 50 |
4003 | 69-D | 50 |
4003 | 69-D | 100 |
4003 | 72-B | 100 |
<tbody>
</tbody>
In Sheet 2. I want to have an additional row called Total Stock which will automatically calculate the stock value of the line number. So Line number 4003 will bring back a value of 50+100+100.
this will then be used to do a true or false check on sheet 1 (does stock match?)
Any suggestions are welcome.
Thanks.