Consolidating Various Excel Files

[Mandeep Dhami]

Hi,

I have few excel files that needs to be consolidated every month. All the
columns in these excel files are same just that the data in each of the files
would vary in terms of number of rows.

I want to consolidate all these excel files into one master file, where data
would appear in one row after the another row.

Names of the files would change every motnth. Can you help me with this
request.

Cheers,
Mandeep

 

[Roger Govier]

Hi

Ron de Bruin has produced a lot of code for carrying out these tasks.
Take a look at
http://www.rondebruin.nl/copy3.htm

 

[Mandeep Dhami]

Thanks Roger you macro helped me.

Hi

Ron de Bruin has produced a lot of code for carrying out these tasks.
Take a look at
http://www.rondebruin.nl/copy3.htm