Hi All,
I'm creating a timesheet, on the document i have a check box for annual leave, if the box is ticked the cells for your hours are populated with a standard days hours, if the box is unticked it clears the cells. Another part of the document then totals the number of ticked boxes and subtracts it from your annual leave allowance. Currently I have achieved this by writing a load of Macros, this works fine however I would like the document to work on office online (which doesn't support Macros). Obviously i could do very easy IF THEN equations in each cell however i still need to be able to manually enter data into the cell which then be overwritten if the button was ticked. Is there a way to "print" a value to another cell or have hidden sums in cells that would all be compatible with online.
Many thanks,
Andy
