Hello everyone,
I am a newbie and using Excell 2007.

I am using a worksheet which contains formulae, functions and, hopefully at
some stage, some VBA Code that will colour format a number of columns.
This worksheet is updated daily with new data.

At the end of the day, I would like to save a copy of the Current Worksheet
(named after the current date, say Sept 1, Sept 2, etc.) in the current
Workbook (named after the current month, say September), but WITHOUT any
formulae, functions or Codes, retaining only the values and, possibly, the
coloured columns. The saved worksheets/workbooks will be archived in a
folder, will not be needing anymore calculations and will be accessed for
viewing only.

I would like to keep the current worksheet as the constant main working
sheet and have all the data in it erased (after the daily save) WITHOUT
DELETING any of my Formulae/Functions or Codes.
In other words, to start the day with the same worksheet, with blank cells,
keeping all my headers, worksheet title and notes, and most importantly, WITH
all my coding, ready to receive new data.

By the same token, when we arrive to the 30th/31st of the month, I would
like to save and archive the Monthly Workbook (with all the daily saves) in a
folder, open a new workbook (say October) with my still active Worksheet,
complete with all the formulae/functions etc.,

And start anew.

I hope this is clear, if a tad repetitive!

How do I do this? In the simplest way?

Thank you for reading and helping if you can.

Cat