I created this macro for the purpose of automatically changing the data, specifically wire kind and size, of multiple excel workbooks.
This had been helpful for changing large volume of data.

The target circuits will be encoded, as well as the NEW data for Wire Kind & Size.
Click the "EXECUTE MACRO" and select the target files.

Once finished, the new Excel Workbook will be saved overwriting the OLD.

* As seen in the example, the data has been updated.
This macro was able to reduce the time consumed to 94% compared to changing the data manually.


***In compliance with the confidentiality policies of my previous company, I am unable to share the actual macro tool or any related outputs.

       The only material approved for sharing is my training results PowerPoint presentation, where the images above are referenced.