does anyone know how to make a validation list using vba.
i want to create a list in worksheet 2 but the data is on worksheet 1.
using vba.
data range worksheets("sheet1").range("a3:a32")
list would be in worksheets("sheet2").cells(2,2)
thanks for any help!
i want to create a list in worksheet 2 but the data is on worksheet 1.
using vba.
data range worksheets("sheet1").range("a3:a32")
list would be in worksheets("sheet2").cells(2,2)
thanks for any help!