Ok so I have this sheet that when a command button is pressed by the user it takes some cell values and paste them into another sheet. It then clears all the data in cells that are specified and then hides rows for the user to start over. There are some cells that have formulas in them that could be over written by the user if need be. These cells are C132, C133 and C134. Below are the formulas in these cells.
C132 formula is =IF(ISBLANK(C123),"",$Q$109+$Q$94+$Q$79+$Q$64+$Q$49+$Q$34+$Q$19+$Q$4)
C133 formula is =IF(ISBLANK(C123),"",IF(COUNT($W$109,$W$94,$W$79,$W$64,$W$49,$W$34,$W$19,$W$4)>0,SUM($W$4,$W$19,$W$34,$W$49,$W$64,$W$79,$W$94,$W$109),""))
C134 formula is =IF(AND(C125="",C123=""),"",IFERROR(SUM($V:$V)/(COUNT($V:$V)-COUNTIF($V:$V,0)),0))
What I want to happen is after the command button is pressed, I'd like to put these formulas back into the cells where they belong. If the user has changed the cells and manually put in a value.
The code for the command button is this.
Thanks in advance for everythingPlease Login or Register to view this content.
excel 2010
Bookmarks