Store and reuse values inputed by multi users

[ewhaley50]

I have a time sheet that allows a user to select the month, current week, and their name. So what i need help with:

I need to be able to store values of cells based on current selection of month, week and name. So when the month changes their will be zeros or the hours a that particualr person entered before.

Attacted excel file;
Schedule tab: is the main tab where user selects name , month year etc
Formuals tab: controls all the dates etc
Dashboard tab: Sums up values based on month (not complete yet)

[Leith Ross]

Hello ewhaley50,

You could use another worksheet and set the sheet's visible property = xlSheetVeryHidden. The users will not be able to see it but it can be accessed from VBA code. Other options would be to create a text file or save the information in the Windows registry.