Split text from userform across multiple cells
Hello,
I am new to Userform. I didn't even know Userfom 2 days ago. So my knowledge is VERY limited and I was hoping you guys will help me figure this out.
Basically, we will get some data (Product IDs and categories) from our clients and we need to link them.
Country Product ID Category Category IDs
US 1234567890 Books
1234567897 Electronics
1234567898 Accessories
1234567899 Clothing
1234667891 Food
Categories have unique IDs and I will be using VLOOKUP to look for their unique IDs under column "Category IDs" (which are country dependent, therefore country is necessary)
However, most of the time data is quite large (say 100 at a time). To add each product ID and their category is quite time consuming. In the userform, I wil select the country,Copy and paste all the product IDs & Order IDs in the respective fields.
So what I am hoping to achieve is when I click Submit, I would prefer it the product IDs be split (one product ID in each row) instead of all product IDs in a single row.
So I will have two columns with product IDs and orders IDs. I can then use AND function to make their combinations and then feed it to an app we use which will link them easily. This will save a lot of time.
As I am unsure how I can attach the sample file, I uploaded it to my Google drive:
https://drive.google.com/file/d/1nXq...ew?usp=sharing
Thank you in advance for helping me out.
Bookmarks