For code see Ron de Bruin's site.

http://www.rondebruin.nl/tips.htm

Scroll down to "Copy/Paste/Merge Examples" and browse through the listings.


Gord Dibben MS Excel MVP

On Tue, 3 May 2011 16:51:50 -0700 (PDT), dinesh rekulapally
wrote:

Hi...

I want to write a macro to club similar data present in different work
books into a single work book. This macro should be dynamic in itself
means that if I'm varying the number of rows (because of increase or
decrease in data next time) in these individual worksbooks when I run
the macro then it should be able to take these total number of rows
into the new work book. Please help me in either writing a macro for
this kind of problem or with a source code.

Thanks and Regards,
Dinesh Rekulapally