Hello, does anybody know how to take information from an Input Box and merge it with information from a Column. It cannot delete the information from the Column it would just need to put an empty line between the information. I included a test sheet with the basic information I would have. When you hit the input button the Input Box will pop up. If I put in the Input Box that this is only a test then the first example will then say in Column E:
this is only a test
Hello

The information inputted in the input box would need to go into every file that has information in Column C. Any help is appreciated.
test macro.xlsm