Hi

I am a novice with excel at this level so any advise would be great. It may
be people can also suggest a better way to solve my problem than struggling
with excel and i would really appreciate that also.

my task:

I am to produce an easy-to-use spreadsheet to record in-coming messages to
my office. The spreadsheet should be usable over a small network. Ideally
there would be an easy way to archive messages at the end of each day or
possibly week. Most of the people who will be using this spreadsheet will
have minimal expertise with excel.

So far:

I have created a simple - to my mind any way :) - spreadsheet with several
colums and some drop down menu's for common matters - eg, who it is for,
query type etc. and i have conditionally formated some sells to indicate what
stage an enquirey is at.

My problems:

I would like to create macros to do the following:

a) merge the day's (or week's) messages to a single ongoing archive worksheet

b) reset/recreate an empty worksheet that preserves all my original
formatting for the new days messages.

c) have an easy way to populate the date and time as each entry is made.

Sorry if I am asking a lot in one post but i thought it better to just
explain the whole thing and see what suggestions i get. Thanks in advance.