Merging one sheet to another using vba

QuestionEdit

Is it possible to merge/append the contents of one worksheet to the end of another sheet using VBA/Macro - while both the sheets are in different files?

AnswerEdit

It is possible. You would have to copy data from one sheet and using Activecell.offset(1,0) and Xldown utility you have to paste them below the existing data

Also, by using Activecell.offset(0,1) & Xlright you can move right to merge.

Will send you some sample macro soon. I do not have them right now.