Trying to Combine Workbooks

[ryan.lindner@gmail.com]

I have A Number of different workbooks with different filenames in a
single folder. All Excel files have the same heading rows, & # of
columns. Basically I want to set up a macro that will look in a
specified folder, take all the data from all files, and put them into a
Master File. I am not very experienced at programming, but this is
something that I have to do every day and this could truly help
streamline what I am doing. I am sure this can be done, just not sure
where to start. Can anyone point me in the right direction? Thanks so
much!
Ryan

[Ron de Bruin]

Try this Ryan
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


<ryan.lindner@gmail.com> wrote in message news:1145389231.798807.203170@j33g2000cwa.googlegroups.com...
>I have A Number of different workbooks with different filenames in a
> single folder. All Excel files have the same heading rows, & # of
> columns. Basically I want to set up a macro that will look in a
> specified folder, take all the data from all files, and put them into a
> Master File. I am not very experienced at programming, but this is
> something that I have to do every day and this could truly help
> streamline what I am doing. I am sure this can be done, just not sure
> where to start. Can anyone point me in the right direction? Thanks so
> much!
> Ryan
>

[ryan.lindner@gmail.com]

Ron,

That was exactly what I was looking for! Thank you very much!

Regards,

Ryan

Ron de Bruin wrote:
> Try this Ryan
> http://www.rondebruin.nl/copy3.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> <ryan.lindner@gmail.com> wrote in message news:1145389231.798807.203170@j33g2000cwa.googlegroups.com...
> >I have A Number of different workbooks with different filenames in a
> > single folder. All Excel files have the same heading rows, & # of
> > columns. Basically I want to set up a macro that will look in a
> > specified folder, take all the data from all files, and put them into a
> > Master File. I am not very experienced at programming, but this is
> > something that I have to do every day and this could truly help
> > streamline what I am doing. I am sure this can be done, just not sure
> > where to start. Can anyone point me in the right direction? Thanks so
> > much!
> > Ryan
> >