Hi,
I created an excel sheet using the data validation function to create drop down lists, however I have now decided to increase the range of data for which each list grabs its data from and I am presented with the error:
"The list source must be a delimited list, or a reference to a single row or column"
I am confused as I never encountered this problem before.
I want to change the drop down lists for B3:F3 to cover the range J4:O8.
It is currently set to J4:M8.
If anyone could help me out here it would be greatly appreciated!
Bookmarks