Forum Discussion
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
| Entity Division(Location) | Item Code | Item Name | UM | Godown | Godown Name | Closing Quantity |
| EL-3 | IC7 | IN7 | PCS | GD8 | GN8 | 6 |
| EL-5 | IC7 | IN7 | PCS | GD9 | GN9 | 433 |
| EL-7 | IC7 | IN7 | PCS | GD7 | GN7 | 6 |
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
- Any solution pls
