Stock generate in drop down list

[rameshppc]

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..

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>

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...

 

[rameshppc]

Hi justy,

I have changed few this in your formula and it resulted what i was expected.

Its really success by your initiate and continuous effort to fulfil my requirements.

Thanks for for your support and you have to see that what i have changed,

https://www.dropbox.com/s/tj69d6wog6pv6vx/BAG BUSINESS.xlsx?dl=0

 

[JustynaMK]

It's looking really nice! Good job
Take care!