Change multiple workbooks at one time

[EGR2317]

Hello all,

I have a workbook that I have already implemented for a lot of different products within my company. Today, my boss noticed that one of the drop down lists wasn't up to date, so he asked me to update it. I have done so, and saved the template with these changes. My question is: is there any way to go in and make this change to all of the other files or do I have to go into each file and make the changes. Thank you in advance for any help you can offer.

[mrice]

Sounds like it should be possible via macro. The easiest implementation would be if all the workbooks were in the same folder and the code could then loop through them all and reset the validation on your chosen range.

Would need to see a couple of actual workbooks to help more.

[EGR2317]

Thanks for the insight. I have actually almost finished with the process manually. I hadn't been able to mark as solved before now.