Help with daily data entry form & calculations

[champey]

Hello,

I'm hoping I can find a solution. I work in an office where we take daily statstiques which are currently recorded on paper and then coallated at the end of each month. I'm trying to find a solution whereby
1. the same 'form' could be filled in online in excel (this I can do but cant work out how to protect the form elements from being changed (there are drop down menus etc and I wouldn't want the formatting to be altered - just the data entered).
2. and the daily totals calculated automatically (this I can do!)
3. then for the daily info to be stored and added to the totals for the month.

I looked at possibilities of excel wizard access combinations but can't work out how it works?

I can send you a copy of the form I created if this helps.

thanks

 

[crimson_b1ade]

Item 1:
To protect elements of the worksheet/workbook go to Tools on the menu bar then select Protection then Protect Sheet. Before you protect the worksheet you'll want to right-click the object(s) that you want protected or unprotected and format their properties. For instance, in the case of worksheet cells, right-click a cell you want users to be able to modifiy, select Format Cells, on the Protection tab ensure the Locked checkbox is unchecked. Other worksheet objects such as command buttons, combo boxes etc. also have similiar protection tabs by right-clicking them then selecting Format Control.

Items 2 and 3 of your inquiry can't really be answered because we don't know the layout of your spreadsheet. however, Excel's SUM function or SUMIF function should do the trick.