Hello Ladies and Gentlemen,

I come to you seeking assistance. I am currently working on designing a semi-interactive data base for work, but am coming across some stumbling blocks.

FYI- At work I have access to MS Excel 2k3, but if the solution is more easily achieved in 2k7 I have that at home.

Short story long: I am a security guard who does hourly patrols of my site and must log certain information, as well as any security violations I observe. Currently this is done by hand with no tracking or ability to observe "trends".

I have designed a rudimentary front pagewith all the categories I need, I even managed to get a dynamic date, as well as Weekday squares. Which leads to my question:

Is there a formula that would copy the contents of one worksheet to another?

What I would like is a formula along the lines of "IF A8 = MONDAY COPY WORKSHEET "CURRENT" TO wORKSHEET "MONDAY"

As I'm sure you can tell from the syntax above, I'm new to advanced functions in excel. Any ideas, suggestions, recommended readings?

Thanks