Man, that is so awesome that you know how to write that. I need to learn how to do this. I'll give your script above a go and see if I can learn from it.

But yeah, here's what I'm trying to accomplish:

File 1:
- User enters data on a row.
- Once the data is entered, it should then copy that row to another file in the other files next available row.
- For example, depending on the variable, the row of text will copy to file1, file2 or file3.

File 2:
- Data pastes to next available row.