Merging one sheet to another using vba

Question

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?

Answer

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.