Merge Input Box Information with Column Information

[trevor2524]

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

[Everstrivin]

How would you determine where the new information would go? Do you just want it to go at the end of the list? Where does the file number come from? Where are all of the files that might have information in column C?

The following code puts whatever you type to the bottom of your list:

Please Login or Register  to view this content.

[xlbiznes]

Try this. It is your code with a few changes done.

Please Login or Register  to view this content.

[Mumps1]

I'm not sure if I understood properly but try this macro:

Please Login or Register  to view this content.

[trevor2524]

Thanks Everybody this works xlbiznes. Mumps1 yours works also I was just trying to get the information to show up in the beginning of the cell instead of the end. But I need to know one other thing. How would I get it to put like an [Enter] space between the two pieces of information. I'm trying to get it to look like this so when I import it back into my database it shows up correctly.

New Information Placed on top
Orginal Information on Bottom

Right Now its showing up right besides each other.
Another Test Hello Hello Test

Maybe I'm looking at it wrong or I have a setting wrong.

[xlbiznes]

Ok , you need to change this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[Mumps1]

Hi Trevor. It looks like xlbiznes has answered your question. In reference to my code, change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.