Merging one sheet to another using vba

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:47 PM GMT

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.

Advertisement

©2017 eLuminary LLC. All rights reserved.