I created 3 combo box to list the items.
Created Name Range as Item1,Item2,Item3.
Used code on userform initialize to load row source as Item1.
Userform.Initialize
Item1.rowsource = "Item1"
When I run the form, I am able to see all items listed in Item1.
But the items are duplicated.
Example :
Laptop appears 5 to 6 times and same with desktop.
I want it to be displayed only once.
Also wanted to link Item2 and Item3 based on Selection.
In short, depended combo box as per the condition.
Please let me know how to remove duplicate and create dependent list.
File attached.
I need some inputs from Worksheet and after that when I fill the form, want details to be filled in Worksheet
Looking at attachment, you will understand what I want
I get huge data in which we have rating from 1 to 4
I will put the data in Raw sheet and I want that it should automatically filter 1 and 2 ratings rows and copy it in the main sheet
There should be no duplicate in Main sheet.
So everytime I put the data in raw sheet, I want it to filter the new one and add it to Main sheet
In main sheet there is a column named Audits.
I want the userform to start when any row in column Audit has been clicked.
User form should display info like name, I'd, manager, customer number based on the row user has clicked.
Once the form is filled I want Audit column to be as Yes.
Reply With Quote
