Hi,

I have been trying to automate the consolidation of the "first" worksheet
from several workbook's having two or more worksheet's with same layout. Each
workbook is in the same folder named "Total".

I want the data of the 1st worksheet in each of these say around 25
workbooks in a Master workbook named "Master" in the first worksheet to be
consolidated one below the other.

Kindly help me out on this.
Prashanth KR.

Try the add-in or use the code from the links on that page
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Prashanth KR" <(E-Mail Removed)> wrote in message news:7A96E128-A946-4970-8126-(E-Mail Removed)...
> Hi,
>
> I have been trying to automate the consolidation of the "first" worksheet
> from several workbook's having two or more worksheet's with same layout. Each
> workbook is in the same folder named "Total".
>
> I want the data of the 1st worksheet in each of these say around 25
> workbooks in a Master workbook named "Master" in the first worksheet to be
> consolidated one below the other.
>
> Kindly help me out on this.
> Prashanth KR.
>

Thank you very much Ron...... I got what I required. And your Tip sheet is
excellent. I shall use it for my daily work.

Thanks a Ton,
Prashanth KR.


"Ron de Bruin" wrote:

> Try the add-in or use the code from the links on that page
> http://www.rondebruin.nl/merge.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Prashanth KR" <(E-Mail Removed)> wrote in message news:7A96E128-A946-4970-8126-(E-Mail Removed)...
> > Hi,
> >
> > I have been trying to automate the consolidation of the "first" worksheet
> > from several workbook's having two or more worksheet's with same layout. Each
> > workbook is in the same folder named "Total".
> >
> > I want the data of the 1st worksheet in each of these say around 25
> > workbooks in a Master workbook named "Master" in the first worksheet to be
> > consolidated one below the other.
> >
> > Kindly help me out on this.
> > Prashanth KR.
> >
>