VBA automation

[Narend]

Respected genius!

I want a little help, question is as follows:-

I have 7 nos. of file with the deferent names but same headlines
and I have to compile all the data in a single file by going each file and copying the data
and pasting the same in the master file.
I want this solution by excel vba.
pls help
with warm regards
Narendra
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[shrivallabha]

You can start with concept outlined below:
http://chandoo.org/wp/2012/04/09/consolidate-data-from-different-excel-files-vba/

Also following can be handy:
http://www.rondebruin.nl/win/s3/win008.htm