Data required in User Form Box based on selection
Hi Friends,
Pls go thru my attached link carrying my file. I want that I will select any cell of allocated qty column (in “allocation vs rqd” sheet), in that row’s item code’s entity division(location), item name & godown wise qty should reflect in the same sheet (allocation vs rqd) automatically in a user form in a proper manner. And that data will be fetched from “Stock” sheet.
Even I filer any Data in the “allocation vs rqd” sheet that will not effect on that box , in spite of that if they select any cell of “allocated qty” column earlier that item’s data would be reflected in the same sheet ( in the box) that may be a pop up type box or a box can be kept aside where those data will be reflected even that data also should be copied if required.
Suppose I select S15 cell in “allocation vs rqd” sheet, then the data that would be reflected in that box is giving below
As in S15 cell is showing data of item Code IC7 & closing qty of that code is available in 3 numbers of godowns.
Hope You can understand what I mean to say.
It will be a great help if I get a solution on this.
Regards
Sanndip
Hi Friends,Pls go thru my attached link carrying my file. I want that I will select any cell of allocated qty column (in “allocation vs rqd” sheet), in that row’s item code’s entity division(location), item name & godown wise qty should reflect in the same sheet (allocation vs rqd) automatically in a user form in a proper manner. And that data will be fetched from “Stock” sheet.Even I filer any Data in the “allocation vs rqd” sheet that will not effect on that box , in spite of that if they select any cell of “allocated qty” column earlier that item’s data would be reflected in the same sheet ( in the box) that may be a pop up type box or a box can be kept aside where those data will be reflected even that data also should be copied if required.Suppose I select S15 cell in “allocation vs rqd” sheet, then the data that would be reflected in that box is giving belowEntity Division(Location)Item CodeItem NameUMGodownGodown NameClosing QuantityEL-3IC7IN7PCSGD8GN86EL-5IC7IN7PCSGD9GN9433EL-7IC7IN7PCSGD7GN76As in S15 cell is showing data of item Code IC7 & closing qty of that code is available in 3 numbers of godowns.Hope You can understand what I mean to say.It will be a great help if I get a solution on this.RegardsSanndiphttps://www.dropbox.com/scl/fi/s28x8q1qi5mooxufd389k/trial.xlsx?rlkey=9pnpiz9kxx1g9j0at11ma2a2s&st=tv2yjoh4&dl=0 Read More