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..[TABLE="width: 500"]
<tbody>[TR]
[TD]s no
[/TD]
[TD]date
[/TD]
[TD]bag description
[/TD]
[TD]rate
[/TD]
[TD]qty
[/TD]
[TD]total value
[/TD]
[TD]selling price
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]01/12/2018
[/TD]
[TD]school bag - A
[/TD]
[TD]380
[/TD]
[TD]1[/TD]
[TD]380
[/TD]
[TD]490
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]01/12/2018
[/TD]
[TD]school bag - B
[/TD]
[TD]350
[/TD]
[TD]2
[/TD]
[TD]700
[/TD]
[TD]460
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]02/12/2018
[/TD]
[TD]lunch bag - A
[/TD]
[TD]65
[/TD]
[TD]1
[/TD]
[TD]65
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]02/12/2018
[/TD]
[TD]travel bag - A
[/TD]
[TD]250
[/TD]
[TD]2
[/TD]
[TD]500
[/TD]
[TD]400
[/TD]
[/TR]
</tbody>[/TABLE]

I need to pay the manufacturer, once its sold. so i have below excel to follow this,
[TABLE="width: 500"]
<tbody>[TR]
[TD]s no
[/TD]
[TD]sold date
[/TD]
[TD]bag description
[/TD]
[TD]sold qty
[/TD]
[TD]sold price
[/TD]
[TD]total value
[/TD]
[TD]pay manufacturer amount
[/TD]
[TD]issued amount
[/TD]
[TD]issued date
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]07/12/2018
[/TD]
[TD]school bag - B
[/TD]
[TD]2
[/TD]
[TD]600
[/TD]
[TD]1200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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!