It have two worksheets They are are called NO REPETITION DROP DOWN & SEARCHABLE DROP DOWN. I want to combine both work into one drop down list them put it into worksheet called BYE WEEKS in all green areas. Please tell me how you combine both worksheets please
How to delete a specific value in a list using VBA
'Dimension variables and declare data types
Dim i As Single
Dim Cell As Range
'Save row number of last non-empty cell in column H to variable i
i = Worksheets("Sheet1").Range("H" & Rows.Count).End(xlUp).Row
'Assign the first non-empty cell to object Cell
Set Cell = Worksheets("Sheet1").Range("H" & i)
'Repeat everything between Do and Loop until row of object Cell is equal to 2
Do Until Cell.Row = 2
'Check if object cell is equal to value in cell E3 and is not empty
If Worksheets("Sheet1").Range("E3") = Cell And Cell <> "" Then
'Clear cell E3
Worksheets("Sheet1").Range("E3") = ""
'Save object reference 1 row below current object to variable Cell
Set Cell = Cell.Offset(-1, 0)
'Show a message box telling the user that the value cant be found in the list
MsgBox "Can´t find value: " & Worksheets("Sheet1").Range("E3")
You can use a single combobox that is applied to multiple cells (without data validation).
Here's an example (please read post #2 & #15 in this thread): LINK
If you're interested in this method I think I can amend the code to meet your requirements.