I have a very basic worksheet written in apple's program "Numbers" on my iPad. It has one column and 16 rows. In the next worksheet I have written a form to input duration (hour and min) Once I input all 16 values; the 17th row gives me sum of all durations.
Now I want to have a button somewhere. After clicking this button it should clear all input values (row 1 to 16) so that for next iteration of data entry I have all empty cells. I don't know how I can put button to clear all sixteen values. Please help.
Also is there a way to make first worksheet read only so that data entry is strictly through the form (which is the next worksheet)
and user is not allowed to modify data directly in the first worksheet.