HELLO;

i'm making a simple program to track guest' activities for a small non-profit and i need some help with vb code. i need to write a macro that will add the data of a set of cells to a master file, then reset the cells to zero at a certain time everyday.

can anyone help me with this problem?

thank you very much,
joe

Using Excel for this purpose may not be the most efficient way for what you want to do.

What you can do is to (assuming you are using Windows), schedule a task to run a VBScript (.vbs) file which can simply copy the Excel file with TimeStamp in the name then reset some cells to zero.  Then write a macro in the Master Excel file to process them when needed.

This is just one of the ideas popped in mind while reading.  

____________________________
Knowledge is there to share, not to hide!
-< PATKAM >-