Hello Forum Members,
I need some help how to get an order form prepared.
I have a worksheet full of data. In column A all the product names, col B has all the colors for each product available, col C has all the variations. Each on different row. I want to have another sheet where I could start typing in A1 let say: "Product na" and all the product starting like that would appear and I could pick one and that would fill A1, then A2 would suggest the available colors, then the variants of that particular model would show in A3 in A4 the product number would fill itself, all based on the data sheet.
From my research I found that I can get the dynamic filter to narrow the product names, but how could I get the colors and variations working?
Any pointers or help would be greatly appreciated!
Thanks!
Vick3d
I need some help how to get an order form prepared.
I have a worksheet full of data. In column A all the product names, col B has all the colors for each product available, col C has all the variations. Each on different row. I want to have another sheet where I could start typing in A1 let say: "Product na" and all the product starting like that would appear and I could pick one and that would fill A1, then A2 would suggest the available colors, then the variants of that particular model would show in A3 in A4 the product number would fill itself, all based on the data sheet.
From my research I found that I can get the dynamic filter to narrow the product names, but how could I get the colors and variations working?
Any pointers or help would be greatly appreciated!
Thanks!
Vick3d
