This should do it for ya:
http://www.rondebruin.nl/copy2.htm
At the site, Ron has examples of pretty much any type of copy/paste/merge
routine that you may ever need.
Regards,
Ryan--
--
RyGuy
"(E-Mail Removed)" wrote:
> On Jan 10, 11:16 am, Albert <Alb...@discussions.microsoft.com> wrote:
> > Hi Guys,
> >
> > Can someone send me the code to:
> > combine multiple worksheets into a master file (sheet)
> > automatically when client sheets are closed
> >
> > Thanks
> > Albert
>
> Hi Albert
> What does combine mean?
> What code did you try and where have you got stuck?
>
> regards
> Paul
>