Is it possible to make an Excel macro that moves all of the data validation information on multiple sheets into a separate sheet and changes the source of validation to the new sheet?
I have Excel files that have data validation in the form of delimited lists that are in the data validation window. These Excel files need to be translated but when they pass through the translation management software, the delimited lists are not picked up. Unfortunately, working with the translation management software to resolve this on their end would take months if not years.
To find a workaround for this issue, I wanted to take the delimited lists in the data validation, copy them into a separate sheet and change the source of the data validation in the original cell to the new range on the new sheet (with the copied delimited list).
Is this possible with VBA? If yes, I would appreciate any assistance on the actual VBA as well. Thank you!