Monthly Report
 

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

Monthly Report
 

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

Monthly Report
 

It should be relatively simple to code given an example of your report's
before/after layout with filename/sheet names, etc

"dgmcneil" wrote in message
...
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