Hi Good evening,
I am always happy to get your magical solutions for challenging questions...
I am working in a excel which contains school bag, travel bag & lunch bag inward informations as below..
<tbody>
</tbody>
I need to pay the manufacturer, once its sold. so i have below excel to follow this,
<tbody>
</tbody>Here i need the stock information in bag description column as a drop down list.
If i sold the school bag - B 2nos, then next row this bag description should not show in drop down list.
Also need your suggestion to find the stock quantity also...
I will thanks a lot, which helps me to save the time for working with this excel chart...
I am always happy to get your magical solutions for challenging questions...
I am working in a excel which contains school bag, travel bag & lunch bag inward informations as below..
s no | date | bag description | rate | qty | total value | selling price |
1 | 01/12/2018 | school bag - A | 380 | 1 | 380 | 490 |
2 | 01/12/2018 | school bag - B | 350 | 2 | 700 | 460 |
3 | 02/12/2018 | lunch bag - A | 65 | 1 | 65 | 100 |
4 | 02/12/2018 | travel bag - A | 250 | 2 | 500 | 400 |
<tbody>
</tbody>
I need to pay the manufacturer, once its sold. so i have below excel to follow this,
s no | sold date | bag description | sold qty | sold price | total value | pay manufacturer amount | issued amount | issued date |
1 | 07/12/2018 | school bag - B | 2 | 600 | 1200 | |||
<tbody>
</tbody>
If i sold the school bag - B 2nos, then next row this bag description should not show in drop down list.
Also need your suggestion to find the stock quantity also...
I will thanks a lot, which helps me to save the time for working with this excel chart...