If you run into security issues with macros, just save as macro free, then import module 1, and save as macro-enabled (not sure how this affects protection [protected cells]). Or make file trusted through excel settings. It can obviously be dangerous to open an unknwon file with macros enabled, so that's also why I included the module1.bas so you can look at the code before anything happens (very simple, clearly safe)

Automatically adds columns left of divider line