Ok here is my issue. I created a schedule for a manager to use. While it tallies a lot of stuff, they do not want employees to see all of this. So I created a new sheet that will transfer only employees' clock in/clock out time. Then, when I did that the formula was something like: =Sheet1!A8. Well, it put 0's in spots that I needed blank. So I figured out this formula to fix that: IF(Sheet1!$A$8="","",Sheet1!$A$8). This works perfectly except I have the first formula input in over 800 cells with different cell references but when I copy and paste the new formula, it keeps the A8 reference instead of updating to the formula I currently have in the cell. Is there a way to keep me from having to input the new formula in 800 cells manually? Sorry if this is confusing, I will try to elaborate.
Bookmarks