Hi! I have this code which takes data from one sheet and when running a macro it displays a dropdown.
With Sheets("Indata").Range("Q6").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, _
Formula1:="=IPE!$J$307:$J$324"
.IgnoreBlank = True
.InCellDropdown = True
End With
How can I in Formula1 add values from 2 more sheets named HEA and HEB. They are within the same range as "IPE!$J$307:$J$324". How can I also write the code that within range J307:J324 it skips the blank cells in that column
Thankful for any kind of help.
Bookmarks