merging files with macro

**np1966** · 03-11-2009, 11:47 AM

i have five files. i have to merge these files into 1 file . if i create a macro, it is working for these 5 files. if the no of records increased in these files , the macro created earlier is not able to merge these 5 files. could u give any solution

**arthurbr** · 03-11-2009, 11:51 AM

Moved to programming forum

**ravishankar** · 03-12-2009, 02:37 AM

Hi
need more info on the layout of your sheets before and after merging.
Ravi

**daxsharma** · 06-26-2012, 11:53 AM

Hi, I need help with this too. have got the same problem.

Thanks
Daksh

**arlu1201** · 06-26-2012, 01:33 PM

Daxsharma,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.