Merging one sheet to another using vba

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


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?


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.


©2024 eLuminary LLC. All rights reserved.