In my workbook, I have a "LookUpLists" sheet that has all kinds of data relating to different fields in the userform, (most of which are dynamically named to go into the userform). What I am curious about is this:
The user must input a SKU # and a Storage # in the userform (located on the front page) I would like the userform to be a little smarter and give the user an option based upon what SKU is put in, so in my example you can see that SKU 12032, has 2 Storage #'s;N34-33-A, and N51-33-A, this is based upon information in the "LookUpLists" sheet column S "StorageList" is its dynamic named range, (column T "SKU (Storage #)" is directly related to Column S the "Storage #".
Hopefully that explains well enough, so is it possible for a userform, to have a pop-up, or another option after you put in a SKU, asking which storage location it came from?
If it is and you don't know how to do it, please let me know, if you know it is not please tell me that to, any feedback is appreciated.
Bookmarks