thanks!

I think it will be ideal to do it that way.


"Joel" wrote:

Yuo may want to consider a Form for your entry. the form can have a button
after all the entries are made which will add the time. The button will move
the data from the form to the worksheet.

A templete sheet can be included in the workbook which is hiden that can be
used for the blank worksheet. A Copy of this sheet can be made on a daily
basis. I would include the data and time in each worksheet name so you can
tell when a blank worksheet need to be created.

See this microsoft webpage for more detains.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

"mattesse" wrote:

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.