Jef Gorbach
12/16/2006 6:51:00 AM
It should be relatively simple to code given an example of your report's
before/after layout with filename/sheet names, etc
"dgmcneil" <dgmcneil@discussions.microsoft.com> wrote in message
news:26EF0B03-AD8E-4F55-A424-5EB096E49E18@microsoft.com...
> more detail please...
> --
> DGM
>
>
> "Martin Fishlock" wrote:
>
> > Yes you can write a macro that will do all of that.
> >
> > It really depends on what data you have and how your report is
formulated.
> >
> > --
> > Hope this helps
> > Martin Fishlock
> > Please do not forget to rate this reply.
> >
> >
> > "dgmcneil" wrote:
> >
> > > At the end of each month, can excel create a new workbook using an
existing
> > > template which reflects the current month (rollover). And taking a
data
> > > column from the previous month and transfering it into a data column
for the
> > > current month?
> > > --
> > > DGM