Hi Team,

I have a split macro which will split an excel sheet into many files based on individual name and save it in a drive (C:\). Here my problem is, I have set the data validation referring to a name range called “Final” in column “E” but when I split the macro, I couldn’t see the validation in individuals sheet. Please advice is there any way that I could resolve it.


Thanks,
Vignesh