Hi there,
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.
Th
Bookmarks