I'm trying to use this, but need to make some adjustments but am not able to figure it out. I'm not very advanced with VBA.
My questions are:
1. How do I do this between two different workbooks, instead of sheets?
2. I don't want to clear contents, I only want to add new content. How do I do that?
3. I want to copy only specific cells in the row (for example, A1 to A1, B1 to B1, C1 to D1)
I couldn't find a forum to post this question.
Any help would be appreciated.