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