Data Validation Drop Down List

[wiwchar]

I have a workbook with a data entry tab where I have needed to restricted the entry into one of the columns to be consistent. I used a Drop Down list to accomplish this.

Next, I have information from this tab copied to other tabs based on certain criteria. This is accomplished with VB. Here is where my dilemma is. When the information is copied over to other sheets, each row has a drop down window. How do I solve this to just take the value from the data input sheet and paste without the drop down window?

Thanks in advance.

 

[Ferdi24]

You could do one of the following:

Instead of normal copy & paste use copy & paste special:

' Cell "A1" has a validation
Range("A1").Copy
Workbooks.Add
ActiveCell.PasteSpecial xlPasteValues

Or remove the validation after the cell has been pasted into the new workbook:

Range("A1").Validation.Delete

Or do not copy but go stright for setting the values via VBA:

dim wb1 as workbook, wb2 as workbook
set wb1 = activeworkbook
set wb2 = workbooks.add
wb2.sheets(1).range("A1").value = wb1.sheets(1).range("A1").value

 

[wiwchar]

Great! Thank you. The second does the trick by removing the validation.