I am trying to create a spreadsheet to record worker productivity. I have two identical sheets with the file, using one for data entry and one for showing the totals. When I recieve a paper record for a completed task, I want to be able to click on the type of work comepleted on the "entry" sheet and have it add a value of 1 in the corresponding cell on the "totals" sheet and then rturn to the "Entry" sheet. I had one macro that caused all cells to recalculate each time, and another that added a 1 to other cells, but not the one I want. They also seem to recalulate each time I saved. I have the iteration set to 1 so that it does not create a circular reference. Any help?
Bookmarks