So I've perused this thread but to be honest I'm not sure the solution works for me. http://www.excelforum.com/excel-gene...ompatible.html
I have an order form that works in conjunction with a search function. Basically I have a few hundred rows, each with a data validation dropdown for the results of a specific search for that row.
Items can be searched via a 6 digit item code, or through simply typing some characters of the item they're looking for. Currently this is the code in my Data Validation:
TextSearchItem2 is my named range, and I have hundreds of these, one for the results of each specific search. I'm looking to be able to copy my data validation down the column for a couple hundred rows without having to manually go in to the data validation for each one and change my named range manually (TextSearchItem3, TextSearchItem4, and so on).
Appreciate any help.