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

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

--

Regards
Roger Govier

"Mandeep Dhami" <(E-Mail Removed)> wrote in message
news:B99A26D7-3697-408B-9297-(E-Mail Removed)...
> 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
>

Thanks Roger you macro helped me.

"Roger Govier" wrote:

> 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
>
> --
>
> Regards
> Roger Govier
>
> "Mandeep Dhami" <(E-Mail Removed)> wrote in message
> news:B99A26D7-3697-408B-9297-(E-Mail Removed)...
> > 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
> >